Access 2010 Turn off warnings

You may need to be sure your db is in a Trusted Location, which can be set up via that Access UI >>Options>>Trust Center.

Check that first ...

mx

Capture1.gif

File > options > trust center, click on Trust center settings
select Macro settings, select
* enable all macros..
or
* disable all macros except digitally signed macros

see this link

http://msdn.microsoft.com/en-us/library/bb203849.aspx

scroll down to
Figure 3. Choosing whether to run macros and whether you receive notification if macros are disabled

I probably need to provide more information.  For instance, I have a button on a form.  When this button is triggered it runs 3 different append queries.  Each append query notifies me that it will chagnge the contents of a table (twice).  How can I turn this off?

File > options > client settings ,
Editing section
Confirm options, uncheck Action queries, Record changes

or you can place
docmd.setwarnings off
'run queries here

docmd.setwarnings on

if you are using sql statements in VBA, you can use

currentdb.execute sql,dbfailonerror