Execution of a Query at a certain time in the day

[aussieolie]

How do I get a query to execute at a certain time in the day? Dies anybody know the code or a method to do this?
Thank you
Olie

 

[llkhoutx]

Create a hidden form. Set the form's "Time Interval" property to the appropriate time value, note that the units are milli-seconds. Use the form's "On Timer" property to execute your desired code.

 

[aussieolie]

Thanks very much for your help. Where is the invisable property located on the form properties?
Thanks
Olie

[This message has been edited by aussieolie (edited 04-26-2002).]

 

[David R]

It's not on the Property sheet, you'll have to set it via code (maybe macro?)