PDA

Click to See Complete Forum and Search --> : timer in Access


Jul 12th, 1999, 11:16 AM
I want to start a process at a
time selected...
ie: i enter a time into a textbox,
a timer function checks this,
and waits until that time,
and then kicks off my process...
is there a way in Access?

J Staniforth
Jul 12th, 1999, 08:14 PM
What you could do is set the Timer Interval on the form's properties Event Tab to some value to make it fire at the interval you want e.g. every minute.
Then put the code into the On Timer event. This code first checks if Now (formatted to only output the time part) is greater than the time you specified - if it is then run the required code.

Hope this helps.
Regards,
John.