2) If you are distributing the application to many users
the following code turns off and on the action queries
when the form is Open or Closed.  The first 3 lines should
appear at the top of the form module.

Option Compare Database
Option Explicit
Public change As Boolean
Private Sub Form_Close()
    'Turn messages back on
    If change = False Then
    Application.SetOption "Confirm Action Queries", True
    End If
End Sub

Private Sub Form_Open(Cancel As Integer)
    Dim x
    'Confirm record changes is on turn messages off
    x = Application.GetOption("Confirm Action Queries")
    If x = True Then
    Application.SetOption "Confirm Action Queries", False
    change = False
    End If
End Sub

1.

DoCmd.SetWarnings False
DoCmd.RunSQL("MySQLString")
DoCmd.SetWarnings True

2. (better, in that errors are easier to trap; worse in that it's a
bit more code):

Dim db As DAO.Database
Dim qd As DAO.Querydef
Set db = CurrentDb
Set qd = db.CreateQuerydef("", "MySQLString")
On Error GoTo Proc_Error
qd.Execute dbFailOnError
<...>
Proc_Error:
 <error trapping code>

                  John W. Vinson[MVP]    
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public