[AccessD] How to turn off the warning messages

To turn the warnings off before running the query
docmd.setwarnings false 

Then to turn then back on after running your query 
docmd.setwarnings true

ie

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryYourQuery"
DoCmd.SetWarnings True

HTH

Rusty

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tina Norris
Fields
Sent: Tuesday, June 24, 2008 1:51 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] How to turn off the warning messages


Hi Group,

I know we've talked about this one before, but at that time I wasn't 
paying attention.  Now, I need to know how to do it, so, I apologize 
before putting the question out there to you all.

I have a form with a calendar control for setting the "deposit date."  
Then there is a button for running a make-table query that will build a 
temporary table of contributions matching that "deposit date."  I want 
it to run without warning the user about deleting the existing table, or 
about making a new table, or about appending the records to the new table. 

Once the table is created, the user will click a button to get the Word 
document into which the contributions information will be merged.

I need to know if I can turn off those warning messages generated by the 
make-table query - and how to do it.

Thanks very much,
Tina
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************