Search results

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...

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.

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...

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...

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

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.

Can anyone please help me with this? Thank you. I am using a form to input query parameters. (test file attached) I used the following query (Returns all values on table when not filled) Problem: entering 3 returns values of 3, 13, and 33. (Because of using "*") How can I modify so that...