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 » Schedule Running a Macro

	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

Schedule Running a Macro

Resolved · High Priority · Version 2003

ReplyThu 20 Nov 2008, 17:51Delegate Paul said...

Schedule Running a Macro

Hi,
I have a macro that I need to periodically run to append data to a snapshot analysis table.
The macro and the VB works fine but I need to find a way of getting the macro to run at the same time every week for consistency.
Any ideas?

Thanks
Paul

For upcoming training course dates see: Pricing & availability

ReplyFri 21 Nov 2008, 13:35Trainer Laura said...

RE: Schedule Running a Macro

Hi Paul

Thank you for your question regarding scheduling.

Access does not include a method to automatically execute a procedure at a particular time unless the database was constantly open and a procedure constantly running to check the time. That causes issues with backups and is not a workable solution.

There are various products available that could open a file that executes code to manipulate your database, or your IT support team might already have a scheduling system that you could use.

Laura GB

Thu 27 Nov 2008: Automatically marked as resolved.

Access articles

· When Is Microsoft Access Not The Best Choice For Your Business?
· What Are The Benefits Of Publishing Your Microsoft Access Database?
· A Greater Understanding Of Your Business With Access Reports
· How To Filter And Sort Data In Access 2010 Tables
· Create A Simple Form In Access

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

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

How do I link tasks

» Forum post: Microsoft project

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