Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access vba

ResolvedVersion 2003

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

Wed 7 Oct 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.14 secs.