timer to run macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro to update a table. It is manually run daily. I think a timer
would work for this. Can someone help me with the code to do this? I'm very
new at getting the code to work! I can leave the database open so that the
timer can run.

I'd like to see how to do this at a set time each day and also the option to
update say every 4 hours?

Thanks!!!
 
If I were in your shoes I would create a single purpose database with an
autoexec macro or start up form that did the update and then quit. I would
use the Windows Scheduled Task Manager to open (and therefore run the update
and close) the database on whatever schedule makes the most sense.
 
Back
Top