Access VBA

Resolved · Low Priority · Version 2003

Fri 25 Sep 2009, 15:20 Delegate Ben said...

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?

Wed 30 Sep 2009, 14:08 Trainer Stephen said...

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

Wed 7 Oct 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips