Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Access VBA

Access VBA

ResolvedVersion 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:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

Access VBA

Access VBA

RE: Access VBA

Access articles

Access tip:

Choosing data types in Access