Run Code Scheduler

[gthull644]

Hi,
what is the best way to run access VBA code at a certain time of the day? I want to set up a form so that a user clicks a button and at 1am the following morning a sub is run.

I can do this using a While loop but obvisously this means that the timing code has to run continuously.

I do not want to schedule the code to run at a certain date, using windows scheduler, as the code will need to be run at different times of the month. Also, specifying an interval using the timer function is of no use.

TIA

G

 

[Dennisk]

your only option is to use a time control on a form, but the form has to open for it to work. So you could develop you app with one form set to hidden.

 

[gthull644]

Just worked out that all I needed to do was add "DoEvents" to my loop!