Stop macro after selecting 'no'

N

naveehgreen

Joined
Jun 7, 2010
Messages
1
Reaction score
0
I have a macro that runs multiple queries (some of them are make table and update queries). Is it possible to stop the macro after selecting 'no'? For example, I am prompted with a notification saying Access will update 1000 rows, but I realize this is the wrong number, so I'd like to stop and investigate without having the other queries run. Instead of having to select 'no' ten or so more times to each of the other queries, I'd like the macro to stop after selecting 'no' the first time. Is this a possibility?

Thanks for your help.
 

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

Transfer Text Macro - How to stop macro if file isn't there 1
Macro with make table 1
skip a step 3
Macro Question 1
User input to continue running the macro 4
Parameterized queries in macro 1
Yes/No pop-up 1
Conditional Step in a Macro 1

Top