How can I make it so that an update query runs automatically (instead of me having to click "Run!" each time I want the data to update?)

Thanks so much!!

If you know how frequently you want the query to run, and you don't mind keeping a form open all the time, you can use the OnTimer event of a form for this.

Set the TimerInterval property to the desired interval in thousandths of a second (e.g. 1000 = 1 second, 60000 = 1 minute, etc.).

Set the OnTimer property to a macro that runs your update query, or write some code to handle this event.

Run the form and you should be in business. Every time the specified amount of time passes, it'll run your query.

HTH

It will run the query even when it's "online"?

Edited by: majahops on Wed Jun 4 15:32:03 EDT 2008.