Full Version: Auto run update query?
UtterAccess Forums > Microsoft® Access > Access Queries
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.
et 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.
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 UA. To view the full version with more information, formatting and images, please click here.