Periodically Trigger Code

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

Guest

I want a piece of code to run every 3.5 hours. How do I get that to happen
without relying on a form to be open to count on the form timmer? Or is
there a way to have a hidden form do it?
 
You can use a timer on a hidden form, or you could create a single purpose
database whose start up form would execute the critical code and then close
the database when it was done. You could schedule this database to open
using the Windows Task Scheduler application. This way the critical process
runs every n.n hours as long as the computer is turned on. If installed on
a server that is always on your critical code will execute every n.n hours
till the server is reconfigured or put out to pasture.
 
I couldn't figure out how to hide the form but here it is.

DoCmd.OpenForm "HiddenForm", , , , , acHidden
 
Back
Top