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?
Printable View
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?
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.