View Full Version : Execution of a Query at a certain time in the day


aussieolie
04-26-2002, 02:36 AM
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
04-26-2002, 02:46 AM
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
04-26-2002, 03:09 AM
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
04-26-2002, 07:42 AM
It's not on the Property sheet, you'll have to set it via code (maybe macro?)