I am running a Make Table query from a macro. How may I stop the Dialogue Box that questions whether or not to delete the target table before running the query?
If you are running the query using VBA, add the following lines:
DoCmd.SetWarnings False
DoCmd.OpenQuery "YOUR QUERY NAME HERE"
DoCmd.SetWarnings True
Make sure you include the last line!
Not sure if you can do that for a macro as I don't use them
However, you can turn off warnings 'globally' as follows:
If using access 2010 , go to File...Options then untick 'Confirm Action queries'
See screenshot
The process is similar for other versions of Access
However, I wouldn't recommend doing this as the warnings are there to help prevent users doing things by mistake