I have a macro that runs a series of updates. Now that everything is working correctly, I want to turn off all the warnings that the update queries pop up, so that it will run straight through. I can't find the command to use in the macro. Thanks!!
I have a macro that runs a series of updates. Now that everything is working correctly, I want to turn off all the warnings that the update queries pop up, so that it will run straight through. I can't find the command to use in the macro. Thanks!!
Look for SetWarnings. Make sure to turn them back on at the end.
I know the command is setwarnings, I've used it in older versions of Access, but I can't find an "action" in the macro builder that allows me to set warnings. That is what has me stumped. Thanks.
Never mind. I just found it - it was "hidden."
No problem. For future users, there's a Show All Actions button on the ribbon.