Search results

  1. D

    List 1 to list 2

    Bump!!1Bump!!
  2. D

    List 1 to list 2

    Here is the image which missed from above post
  3. D

    List 1 to list 2

    I have a task here which i need a great help, i will try to explain in most suitable way, I have list 1 where date and count of a file sent date and count of entries for the date appears, i want when i double click on item it should go to list 2 and disappears from list 1. and on clicking ok...
  4. D

    Bound Form textbox autosearch

    yes, but also to inform i have list around 2000 and if I type A it will show Starts from A and for ABC i have to press down arrow to select, where i need only want to do it in prees of ABC Keys.
  5. D

    Bound Form textbox autosearch

    I have a form bound to a table for updation: Table ------ name address Stat fk ref cod Cod ------ id stat PK in the form in textbox for stat column, shows list type box, and stat has 3 letter alphabet only. My problem is when i press key for enterin Eg. ABC, this shows A and letter starts...
  6. D

    Dcount Problem

    why is it so...because i have if uk format and my machine also have uk format for Date
  7. D

    Dcount Problem

    l = txb_memno.Value d = Format(txb_dot.Value, "dd/mm/yyyy") e = txb_fltno.Value f = cmb_Orig.Value g = cmb_dest.Value They are the values associated.
  8. D

    Dcount Problem

    Attached is for same l = txb_memno.Value d = Format(txb_dot.Value, "dd/mm/yyyy") e = txb_fltno.Value f = cmb_Orig.Value g = cmb_dest.Value
  9. D

    Dcount Problem

    I have a statement int1 = DCount("*", "tblDataentry", "((([tblDataentry].[dateofTravel])=#" & d & "#) AND (([tblDataentry].[flightNo])= " & Chr(34) & e & Chr(34) & ") AND (([tblDataentry].[membershipNo])= " & Chr(34) & l & Chr(34) & ") AND (([tblDataentry].[origin])= " & f & ") AND...
  10. D

    Retrieve Column Name

    It worked..thanks
  11. D

    Retrieve Column Name

    I am sorry, original link is http://www.access-programmers.co.uk/forums/showthread.php?p=1304709#post1304709 where there is all the details, this was accidently gone
  12. D

    Retrieve Column Name

    i have a excel file need to imported, which has nearly 110 Columns, after importing there are required columns which should not be empty, so access will be taking them out from database in form of Excel where it needs "reason for Rejection", stating so and so column data is missing. Reason is...
  13. D

    Retrieve Column Name

    abc def reason 1 2 I have table in which i want to update reason column as "def missing" on 1st record and "abc missing" on second record. Please help, Thanks in advance.
  14. D

    Retrieve Column Name

    i have a table in which i want a column name as output when the data in it is null. Its very less to ask but i need, thanks in advance.
  15. D

    Update and Navigation

    yes, i am storing the username, Please elaborate what you mentioned in the line above.
  16. D

    Update and Navigation

    yes, i am storing username too, but could you be more specific for what u mentioned..
  17. D

    Need help in running this vba code

    I see in the Code the Rst.Edit is there, but no Update is given at the end.
  18. D

    Update and Navigation

    Hiya, I have made a database for data entry, currently i have a challenge of getting it update and navigate. On the form if the staff name is xyz it should only shows the records filled by xyz in form and navigate that records only. I am attaching the data base also, reply will be a great...
  19. D

    Update Query

    I Have two tables: DE -------- id PK orig FK ref id code Dest FK ref id code flag Code ------- id PK cod flag here the code tables have column flag entry as 0 or 1 Problem is if either one of orig and dest have flag entries as 1 or both have...
  20. D

    Update Thing

    I am working on Data entry form where a user can enter the details in the form and save and go ahead, its a single form in default view. I want to provide an edit button with navigation control in this form only where they can edit their wrong record for update. Hw can i acheve this?
Back
Top Bottom