It is possible to turn the warning off ...
WARNING!!! If you forget to turn it back on, Access can be doing things you
didn't expect, and you won't know it until someone notices that the data is
all hinkey ...
You can even turn the warnings off in a macro ...
WARNING!!! If you forget to turn it back on, Access can be doing things you
didn't expect, and you won't know it until someone notices that the data is
all hinkey ...
.... and in the same macro, at the end, you can turn the warnings back on.
WARNING!!! If you forget to turn it back on, Access can be doing things you
didn't expect, and you won't know it until someone notices that the data is
all hinkey ...
Please note that if something goes sideways during either the macro or the
queries it runs, the warnings may NOT be turned back on. To ensure this
hasn't happened, you may want to create another macro that ONLY turns on the
warnings, and get in the habit of running it manually after EVERY TIME you
run your update queries macro.
WARNING!!! If you forget to turn it back on, Access can be doing things you
didn't expect, and you won't know it until someone notices that the data is
all hinkey ...
(hint: it might take a little more work initially, but if you use a
procedure to do those update queries, you can turn the warnings off/on
there, AND you can add it error handling to your procedure that ensures your
warnings are turned back on...)
Good luck!
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.