Full Version: Auto run update query?
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
majahops
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!!
PMPCS
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
majahops
It will run the query even when it's "online"?

Edited by: majahops on Wed Jun 4 15:32:03 EDT 2008.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.