Macro open query action with action fail



I have macro to open a query with the query input prompt. It works. However
if I decided to cancel the query, I got the action failed screen then I have
to click on Halt or 'X' to close the macro.

It is annoying. Please help me to fix that action fail


AFAIK, there's no way to handle errors using macros. if you need to perform
an action that frequently produces an action failed, suggest you use VBA
instead of a macro, where you can include an error handler in the procedure.

if you need help with that, post back with the name of the query, and what
kind of query it is: Select query or action query. i'll give you a hand
with the code.


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