Parameter Cancel Button - Action Failed HELP!!

  • Thread starter Thread starter RustyR
  • Start date Start date
R

RustyR

Good Morning!
I have tried everything I can think of but to no avail.
If I call a Macro which opens a query with 2 date parameters (start and end
dates) but decide to hit Cancel on either input box, I get "Action Failed"
dialog. The only option then is to hit "Halt" - Can this be avoided?
I have set Warnings to No then back to Yes in the macro.

Any help would be greatly appreciated!
Rusty
 
RustyR said:
Good Morning!
I have tried everything I can think of but to no avail.
If I call a Macro which opens a query with 2 date parameters (start and end
dates) but decide to hit Cancel on either input box, I get "Action Failed"
dialog. The only option then is to hit "Halt" - Can this be avoided?
I have set Warnings to No then back to Yes in the macro.

Any help would be greatly appreciated!
Rusty
Click to expand...

One of the primary reasons to avoid macros is that they have no way to handle
errors. If you did this with code instead you could trap for error number 2501
which is raised any time an interface action is cancelled.
 
Thanks for the reply Rick.
I figured that I may have to code it, but being new, I thought there may be
a simple workaround I have missed.
I will code it.

Rusty
 
Back
Top