You can suppress the display of confirmation dialogs by unchecking the
Confirm boxes under:
Tools | Options | Edit/Find
You can suppress further warnings by setting SetWarnings to False (in a
macro or in code.)
And you can suppress the VBA error messages by setting the Error Trapping
under:
Tools | Options | General
(in the code window, not the main Access window.)
You can also suppress errors in VBA by adding this line to the top of each
routine:
On Error Resume Next
However, I strongly suggest you do *not* do any of this.
If you do, you will be left with the false impression that your program is
actually doing what you asked it to do. The reality is that - with close to
100% certainty (unless it's a trivial program) - it will not be doing
anything like what you asked it to do, and you will be none the wiser. It is
a recipe for disaster.
My personal style is to do everything humanly possible to get Access to tell
me when my program is not working as expected. One day I hope to write an
article entitled, "Why error messages are your friends."
