how to run a procedure/function at a specific time

  • Thread starter Thread starter Jeff A via AccessMonster.com
  • Start date Start date
J

Jeff A via AccessMonster.com

Hi,

I need my Access application to run a procedure/function at exactly 1PM. I'm
not sure how to go about coding this.

Thanks,

Jeff
 
One way to do this would be to set up a (?hidden) form's Timer event to
check every (you pick how often) to see if 1) it is past 1 PM, and 2) if
it is, if the procedure was already run. You still need to write the
procedure.

Another approach is to buy a product that lets you schedule an Access
procedure.

The former has the disadvantage of requiring Access to be open at 1 PM.

The latter has the disadvantage of cost.

Regards

Jeff Boyce
<Office/Access MVP>
 
Thanks! The first approach is more practical for me for the time being.
 
Back
Top