[AccessD] How to turn off the warning messages

Thanks Rusty - that's exactly what I needed.
Tina

rusty.hammond at cpiqpc.com wrote:
> 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
>