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.
 
You must log in or register to reply here.

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.

Ask a Question

Similar Threads

Timer of Form 4
Access Access Open and Close a Timer Form running on an open database on another computer 0
Looking for a 13A plug-in Digital Timer to switch on at dusk . . . 9
Cancel timer event if criteria not met 1
Ac 2007 Timer hangup in ACCDE 2
Understanding Timer Pause Code 6
Timer 8
Timer Count 9

Back
Top