Search results

  1. O

    Subform Height Change on Base on REcords

    Hi All Can i change Subform (DataSheet view) Height based on records showing or any textbox value..
  2. O

    Automated Field Data

    Please help me now i am doing it following steps first create a table named "Pay_no" with query "qryPay_No" then secondly Create other table "PAY_CODE" containing "PAY_CODE" with "qryPaycode" for concatenate two fields then finally get results within desired table"Final" with Dlookup but this...
  3. O

    Automated Field Data

    find table and qry my original data having records more than 100000.. when i set default value for field Pay_No as query it shows error massage like screen shot attached.. please help me
  4. O

    Automated Field Data

    thanks but how can get Pay_No in one field,, when i got it by query , query run very slow,
  5. O

    Automated Field Data

    Hi i have a table name "FinalData" in this table i have Seven fields , "EmpName", "EmpID" , "Post","PAN","Account" , "PAY_NO", PAY_Code" "Pay_No" and "Pay_Code" Depends on Other Fields like EMPID and PAN "Pay_No" = Count of Empid before this record "Pay_Code"= "Empid"&"/"& "Pay_No" i want to...
  6. O

    Run fast query

    I am running a query to sort, and giving code to a field from other table... it this query no sum, no *, but it runs very slow
  7. O

    Run fast query

    My means is Number of records in table are more than 10 millions..(>100000)
  8. O

    Run fast query

    HI I am running a query in my data base which having records more than 1 lacs.. when i open a query to place codes of field values.. it runs very very slow.. in app.15 mins. how can i run it fast.? is any temp table help me ? if yes then how ? please help me...
  9. O

    Dlookup in if condition

    yes.. i am using dlookup in query may not? then how can i solve this.. please give me step by step solution thanks once again
  10. O

    Count Records in Table

    thanks once again but previous code is working fine with my data
  11. O

    Dlookup in if condition

    Hi i want to update data in table A where [EMPID]= null with other table B i m using formula as =IIf("[EmpId]"="#N/A",DLookUp("[Empid]","[B)]","[Account]='" & [Account] & "'"),"[EmpId]"="[EmpId]") but it gives a messege of error please tell me where is my fualt thanks in advance
  12. O

    Count Records in Table

    Thanks to all , i got solution with with sneuberg's solution..
  13. O

    Count Records in Table

    Re: Count Records can i add column in table or in a query to count total records as EMPID (Count of EMPID) till row
  14. O

    Count Records in Table

    can i add a column as count record of EmpID
  15. O

    Count Records in Table

    Re: Count Records Oh... Sorry i think i can't explain Column "S" is not a column i.e. S.No.(Serial Number) a column which having total no of entries..
  16. O

    Count Records in Table

    How can i use it
  17. O

    Count Records in Table

    Count Records Hi i have a table containing following fields S.No. EMPID Item Date Count Item/Empid 1 A01 Apple 08/09/2016 A01/01 2 A01 Banana 10/09/2016 A01/02...
  18. O

    Change Subform Columnwidth auto when change data

    thanks arnelgp but it doesn't works when data change in sub form why not and in your code there is an "end if" how can i use if condition i can't understand pls help me
  19. O

    Change Subform Columnwidth auto when change data

    Thanks arnelgp.. But this not working..i dont know why
  20. O

    Change Subform Columnwidth auto when change data

    Hi All i have a form named Form1 and subform named SBFRM subform show data for select query based on value of text box on form 1 subform shows data in datasheet view my problem is . data having diffrent lenght of character as In EmpName Field, Raj Rajkumar Rajkumar Sharma but when it shows...
Back
Top Bottom