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.
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.