How to make sure one query has finished before the next runs

V

vtj

I am running a macro that has a series of queries. I do a maketable query
followed by an update query that uses the table just made to update totals
records in another table. The maketable is not finishing before the update
runs and I do not get the correct information transferred. Is there a way to
make sure that the maketable query has finished before the update query runs?
I have tried requery and putting another query in between but it doesn't
help. Running the Macro in step mode produces the correct results as does
running the udate query outside of the Macro. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to wait until an excel spreadsheet macro has finished runnin 0
query completions in code - threading issue? 1
How to make the application wait until ODBC Extract is finished 2
How to delete previous data from 1 macro before running the next m 1
How to display status of macro progress on screen 1
Make Table Query-Running a make table query before you open a for 4
Need to make sure workbook is open before proceeding 1
How do I know a query is finished? 11

Top