Yes; if you're running the query from a Macro or from VBA code, put a
line to set SetWarnings to False before running the query. Be sure to
put Setwarnings back to True afterward, or you'll turn off ALL warning
messages for the rest of the Access session.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.