macro actions in sequence

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

Guest

I don't know what I have done wrong that the macro actions are not working as
I listed in my Macro? Let me explain a little bit: I have a macro set up for
6 actions (OpenQuery) of 6 queries. 1st, 3rd and 5th are the appending
queries of 3 different tables to a master table and 2nd, 4th and 6th are the
deleting queries of those 3 tables, in other words, the 3 deleting queries
are to delete the lines after having appended to the master table, then I
added an extra action: StopMacro. Yet the 6th query started first? Please
somebody help me out of this? thanks.
 
Karen,

This is very unusual behaviour... I have never seen anything like this
before. The queries would normally run in the sequence you have them in
the macro. Are you sure you have the macro set up correctly? What
happens if, as an experiment, you remove the 6th OpenQuery from the
macro? Do the other queries work as expected if you run them separately?
 
Thanks for your advice, Steve. Through your suggestion, I looked into it,
YES! i found the error: there was 1 query posted in wrong sequence. sorry
for mis-lead. I appreciate your reply to force me double check!!! (actually
I did check so many times but my eyes were crossed...)
Karen
 
Back
Top