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

[Guest]

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

 

[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).

 

[Guest]

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

 

[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.

 

[gerbernj]

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

I am in VERY interested in a response to this questions as well using Windows Scheduled Tasks XP. Has anyone gotten a response to this?

 

[Guest]

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

 

[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