Update Querys in a Macro

N

neenmarie

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

Steve Schapel

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?
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Setting language of a selected text in Office apps. 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Visio 2019 crashes when attempting to open drawing. 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Want to have macro execute automatically when doc created 3
How to modify and updte specific styles for specific paragraphs across the document 0
Getting Radio Buttons to work, that are inserted via AutoText 0

Top