macro actions in sequence

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.
 
S

Steve Schapel

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?
 
G

Guest

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
 

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

Top