Re: Turn off sql warnings

From: RobFMS (Rob_at__xIgnoreThisx_fmsinc.com)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 09:54:48 -0500

The statement is: Docmd.SetWarnings FALSE

To turn them back on: Docmd.SetWarngings TRUE

BE CAREFUL with these statements. If you turn the warnings off, they are off
for the ENTIRE application and (I believe) the settings are saved when you
exit the application. If someone has access to the database window and hits
the delete key on one of the objects... BYE-BYE!

Make sure you turn it back on when you exit the subproc or function. For
example:

Public Sub TestMe()

  On Error GoTo Proc_Err

  Docmd.SetWarnings False
  :
  : code goes here
  :

Proc_Exit:
  Docmd.SetWarnings True

Proc_Error:
  Msgbox Prompt:=Error.Description
  Resume Proc_Exit

End Sub 

-- 
Rob
FMS Professional Solutions Group
http://www.fmsinc.com/consulting
Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"Erik T" <ErikT@discussions.microsoft.com> wrote in message
news:C1FCDD11-4D37-4587-8A69-9BD07021A84D@microsoft.com...
> I receive the following "warnings" when running an SQL statement -
>
> The existing table 'tablename' will be deleted before you run the query
>
> then
>
> You are about to paste XX row(s) into a new table
>
> How can I turn these messages off?
> Thank you