- Joined
- Apr 30, 2012
- Messages
- 1
- Reaction score
- 0
Hello,
I am creating a Access 2000 database to manage tool room activities. I have a form using 2 unbound text boxes (independently) to search for records.
For example one text box searches for the Tool ID 1-1234 and the other for the Calibration ID E-12345. You can do a search for one or the other or both.
What I want is when the query returns 0 results to append the values in the unbound text boxes to a "Tools Not Found" table so I can later (after I go through all the record I want to update) go to the Excel workbook I imported the records from to add them to my records in Access.
I am creating a Access 2000 database to manage tool room activities. I have a form using 2 unbound text boxes (independently) to search for records.
For example one text box searches for the Tool ID 1-1234 and the other for the Calibration ID E-12345. You can do a search for one or the other or both.
What I want is when the query returns 0 results to append the values in the unbound text boxes to a "Tools Not Found" table so I can later (after I go through all the record I want to update) go to the Excel workbook I imported the records from to add them to my records in Access.