Ben has attended:
Access VBA course
Access VBA
in a database full of possibly unused queries, is it possible to set up a log of when queries are run so that unused ones can be safely deleted?
RE: Access VBA
Hi Ben
Thanks for your question
The simplest solution would be to set up a form/swithboard from which all queries must be run. I would suggest the following;
1. Populate a combo box with a list of all the queries on the database.
2. Create a comand button that opens the selected query.
3. Add a table to the database with fields for query name as well as date and time of the run
4. From the command button run a procedure that adds the relevant information to the table
Hope this helps
Regards
Stephen