Deactivate warning messages for query

[math20]

Hi,

I have about 15 queries that run to generate a report. Is it possible to somehow deactivate the warning message that pops up for each query that I run. Some of my queries are make table queries. If possible I would like to minimize the user to have to click on those 15 warnings.

Any help will be highly appreciated.

Thanks.

 

[PHV]

Have a look at the DoCmd.SetWarnings method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gusbrunston]

PHV's right. In VB that's the command to use. If you're opening your queries in a macro, you can begin the macro by turning the warnings off, and end the macro by turning them back on.

[tt]
Gus Brunston - Access2000/2002(DAO)[/tt]

 

[BSman]

Also, you can go under options/Edit and uncheck the three boxes related to confirming updates and deletions. This will eliminate the confirmation for all updates, etc., that run properly.

Bob S.