How to run a function at specified time

[CharlesWhiteman]

Hi All, I have created a module which runs a query and sends out emails.

I would like to be able to specify a time that the module runs but think there may be limitations using the OnTimer event.

Any thoughts/advice?

Thanks

 

[pbaldy]

Depending on the frequency, I'd be more likely to create an mdb that performed the desired task when it started, then closed itself. Then I'd call that mdb from Windows Scheduled Tasks at the desired time.

 

[CharlesWhiteman]

Thanks P, That was option I was also considering but not favouring. As the application is essentally providing a monitoring I think I may put in a number of monitorng wanrings which can be sent out before it needs to be manually reset.