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.

--
Ron W
www.WorksRite.com
"Matt Sonic" <(E-Mail Removed)> wrote in message
news:6221CFE2-F6E8-4D00-ACC9-(E-Mail Removed)...
> 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?

I couldn't figure out how to hide the form but here it is.

DoCmd.OpenForm "HiddenForm", , , , , acHidden

"Ron Weiner" wrote:

> 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.
>
> --
> Ron W
> www.WorksRite.com
> "Matt Sonic" <(E-Mail Removed)> wrote in message
> news:6221CFE2-F6E8-4D00-ACC9-(E-Mail Removed)...
> > 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?
>
>
>