The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Access VBA

Resolved · Low Priority · Version 2003

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

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?

For upcoming training course dates see: Pricing & availability

ReplyWed 30 Sep 2009, 14:08Trainer 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.

Access articles

· Discover the Secrets within Your Business through Microsoft Access Training
· Microsoft Access 2007: New Features
· A Greater Understanding Of Your Business With Access Reports
· Keeping Your Access Database Updated
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data

Please browse our web site to find out more about
2000 access microsoft training and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

How do I animate a chart?

» Forum post: Powerpoint

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions