Hi all,
I need help to turn off the GUI window when a macro hits an error. Here's the situation. I have a query that prompts the user for information. If they decide not to complete the selection, (the selection criteria window you get with a prompt has a cancel button automatically) and the query is running in a macro, the macro error window opens and you have to click stop macros. This is not very user friendly when you are creating a client component in a database. I want to know how to stop this message from showing. (I already have setwarnings to no, but Microsoft overrides that when it gets an error). I've tried 15 variations from Sunday and none of the stopmacro commands or other commands seems to be able to override that window. Here's the thing, if Microsoft is nice enough to give you a "OK" or "Cancel" button on the prompt window, why can't they capture the cancel command in the macro?
Any code around that I can use here?
Thanks,