I have a number of Make Table queries that are in a macro. Although I have "unchecked" the confirm button in Access Options>Advanced> Editing section. It still asks to confirm the operation when the macro is run. Can anyone assist please.
I have a number of Make Table queries that are in a macro. Although I have "unchecked" the confirm button in Access Options>Advanced> Editing section. It still asks to confirm the operation when the macro is run. Can anyone assist please.
Look at the SetWarnings action (make sure to turn them back on).
It's a macro action; should be in the dropdown list.
Many thanks for that, saved me a lot of time
No problem, and welcome to the site!
Don't forget what I said about turning the warnings back on after executing the query. It turns off all warnings, like when you make changes to an object.
In the macro screen, you will need to select "Show All Actions" from the Show/Hide category on the Design Ribbon.
Took me a while to find it!
Brilliant, thanks.