I have a module of code that runs several make-table queries consecutively. They are querying from a very large database (several million records) that is linked to the Access db, and is located in another state. So I need to insert a pause between each query to allow the table to finish building, due to network delays. How can I do this? It seems like such a simple and silly question, but I can't find anything on it in the MS VBA help or in the forum or FAQs.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pausing VBA code
- Thread starter dgirl1010
- Start date
Has an example of writing a custom pause. You may have to mess with the pause.
If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]
- Status
Similar threads
- Locked
- Question
- Locked
- Question