Macro open query action with action fail

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

Guest

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.

hth
 
Back
Top