Timed Event

  • Thread starter Thread starter Dion
  • Start date Start date
D

Dion

I am somewhat new to this but... I was wondering if
anyone knew of a way to set a timed event to occur. What
I am trying to do is open a program called Monarch and
import a file into an Access 2002 table at 6:00AM. Any
ideas would be extremely helpful in pointing me in the
right direction. Thanks in advance.
Please only respond in this newsgroup.
 
If you leave the Access database up and running, you can
set a timed event on an open form. The form can be hidden
if you like, but it has to be open. Create a form, then
set a VBA module or a macro to run once a minute ( Timer
interval = 60,000). Have the code or macro that is run
check the current time and if it is 6:00am, call another
module or macro which imports the desired data.

There may be other ways, but that is how I have tackled
something similar.

Hope that helps!
 
Back
Top