Update Querys in a Macro

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

Guest

I've combined several update queries into a macro so my users can click one button and update all the needed info at once. All the queries work fine on their own, but when combined into the macro, they don't all run and update. If I change the order they're listed in the macro, different ones will work correctly. Any suggestions as to what I've done wrong?
 
Neenmarie,

Are you using OpenQuery actions in your macro? Do some of the queries
take a long time to process? Have you got SetWarnings/No action in the
macro? If so, what happens if you remove this, and respond as
appropriate to the action query confirmation prompts?
 
Back
Top