How do I schedule a macro to run every hour in Access

H

HalfBaked

Is there any way to schedule a macro to run automatically every hour in access?
 
S

Steve Schapel

HalfBaked,

Yes. On a form that is always open, assign the macro on the On Timer
event property, and set the Timer Interval property to 3600000
(milliseconds).
 
T

TwinDad

Steve,

Does the form have to be on the Fore-front (Active) or can it be minimized?
I have the same issues and was thinking of having it run on my start-up form.

any advice?

-TheNovice
 
S

Steve Schapel

TheNovoce,

The form has to be open, but it can be hidden, in the background,
minimised, whatever, doesn't matter as long as it is open.
 
F

Frank681

If I wanted to run the macro every 24 hours or even once per month is there a
way, or do I need to calculate how many m/secs in a month
 
S

Steve Schapel

Frank,

You could use Windows Task Manager, or one of the many third-party
scheduling utilities, to do this. You would probably need a command
line in the scheduler something like this...
"C:\Program Files\...\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /x NameOfMacro
 
Top