Auto execution

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

I have MS Access macros which I want to run everyday at
7:00 AM. How can I do this? Please help!
 
You can either use windows task scheduler to run access with your database,
or if access always loaded - make a new form, which always loaded, set it
timer event to check for 7:00 AM (using Now() function) and then run your
macro using Docmd.runmacro.
 
I have MS Access macros which I want to run everyday at
7:00 AM. How can I do this? Please help!
Click to expand...

does your App run 24 hours?
if yes use a form-timer with intervall: 60000
in the timer event:
if hour(now)=7 and min(now)=0 then
run your macro
endif

else
use the scheduled task from windows to run a mdb
which autoexec is using the makro and the original mdb
 
Back
Top