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

  • Thread starter Thread starter Guest
  • Start date Start date
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).
 
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
 
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.
 
=?Utf-8?B?SGFsZkJha2Vk?= said:
Is there any way to schedule a macro to run automatically every hour in access?
Click to expand...
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?
 
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
 
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
 
Back
Top