pause statement

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

Guest

I am having problems running my macro because think that it is trying to run all the queries at the same time where it really needs to complete the 1st query before the 2nd etc..as each query is looking for results from previous query
Is there a way in visual basic or macro to make sure that the query or macro step has completed before running the next macro step or query

Thanks in advance for anyone's help!
 
I have been having this same problem. I tried in a macro
and found no success so had to switch to VB code -- I
have had some success in running a For...Next loop in
between my macro steps to delay the action:
For I= 1 to 1000
For J = 1 to 1000
Next J
Next I
I hope this helps. the only other way people have
mentioned to me is to step it through holding the shift
key...

Marv
-----Original Message-----
I am having problems running my macro because think that
Click to expand...
it is trying to run all the queries at the same time
where it really needs to complete the 1st query before
the 2nd etc..as each query is looking for results from
previous query.
Is there a way in visual basic or macro to make sure
Click to expand...
that the query or macro step has completed before running
the next macro step or query?
 
Back
Top