Pause/Wait Command

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a macro that runs several update queries and then
sends data to several Excel Reports. Is there a way to
ahve the macro stop until all queries are completed before
continueing?
 
Mark,

As far as I know, there is no elegant way of doing this with macros.
The only way around it, as far as I know, is...
1. Split the macro into two macros, one with the queries, and the other
with the spreadsheet exports
2. As the first action in the first macro, open an unbound form (hidden,
probably) whose Timer Interval property is set to an appropriate amount
of time, sufficient to normally allow the completion of the query processing
3. Assign the second macro (spreadsheet export) to the On Timer event
property of the form.
 
Back
Top