queries running through code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

While using the docmd.openquery method in VBA, does Access pause execution
until the query is completed? The reason I am asking is that I run 2 queries
with this method, the second is based on a table created from the 1st query.
I keep getting the "Unexpected Error" where Access shuts down and am
wondering if this is caused by the first query not completing, then the 2nd
query trying to start. If execution is not paused, is there a way to do so?
 
Hi Luke,

put these statements after the first query

currentdb.tabledefs.refresh
DoEvents

also, instead of docmd.openquery, use

currentdb.execute


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 

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

Form to LoadingForm to run Queries for Report? 1
Run three Queries in VBA consecutively... 2
Any better way to do the query 4
ADODB from Excel - Running a Query 1
Apply Query Criteria in VBA 2
Capture which query is being run 3
Acces 2007 performance 1
Run 2nd query using results from 1st query 0

Back
Top