Recent content by anoo

  1. A

    Transfering values from one form to another - DLookup

    Thank you, Minty and missinglinq. I really appreciate time taken to modify the database and made it work. Marked as "SOLVED".
  2. A

    Transfering values from one form to another - DLookup

    Thank you, Minty Runtime error 3075 Syntax error with this code, Thanks. File attached.
  3. A

    Transfering values from one form to another - DLookup

    SOLVED - Transfering values from one form to another - DLookup Dear Experts, I am trying to use DLookup to get values on a form. On load event of form with code works How to get that value "2" transferred from another form? I tried this and does not work. Could anyone please help me? Text4...
  4. A

    Linking excel with ID (Autonumber) field

    Dear Experts, Could anyone please show how to have a query with ID (autonumber) field and all fields taken from an external linked excel file? Thank you so much for your help.
  5. A

    Append memo using textbox

    Thank you so much. You are very helpful, I really appreciate it.
  6. A

    Append memo using textbox

    Dear Experts, When using textbox (note) to append memo (Notes), how can I have new entries entered before existing text so that new entry appear at the top? (Line2 before Line1) - Sample attached. Command button on click code: is used to append values to memo field. Also, anyone please clarify...
  7. A

    Filter values / Combo box

    JHB, Thank you very much. Grüß aus Aachen, Deutschland
  8. A

    Filter values / Combo box

    Can anyone please help me with my sample database? I want to capture Employee Name, Code, and hours on Time sheet table. Thanks again. (I googled and couldn't follow along :(, If I could see it working on my sample, I am sure.... I will get it) Cheers.
  9. A

    Filter values / Combo box

    Thank you very much.
  10. A

    Filter values / Combo box

    Hi Experts, How can I have filtered values on second combo box based on first combo box selection? 3 Tables: Employee, Department, Codes. Employee table contains a lookup field of Department. Structure: Tom Dept A Code 1, Code 2, Code 3 Dick Dept B Code 4, Code 5, Code 6 Harry Dept C Code 7...
  11. A

    Opening Links (file path) using button from form

    Thank you very much. [Solved]
  12. A

    Opening Links (file path) using button from form

    Dear experts, How to have a button open an external file if the file path is stored in a table. (any file type) Database sample attached. Thank you for your help. Anoo
  13. A

    Filter query / 3 fields

    Thank you, pbaldy. Your solution returns all records when blank.
  14. A

    Format Date on Report (text box)

    Solved. Thank you very much.
  15. A

    Format Date on Report (text box)

    Dear Experts: I use a text box with control field to display date on a report. Is there an easy way to format the date range on report to "Medium Date"? (15-Feb-17) - test file is attached. Thank you so much for your help.
Top Bottom