supress warning messages 1

[fredk]

I did find a thread that was archived that advised how to stop the warning messages by clicking Tools - Options - Edit/Find Tab. In the Confirm section, uncheck Action queries.

However, this stops them for all - I just want to supress them for one database. I have a database that uses several queries... the first creates a table and several others update this table from different data sources. I use a macro to run all of the queries.

How could I supress the warnings just for this macro? Thanks for your help!!!

Fred

 

[PHV]

Have a look at SetWarnings

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

 

[fredk]

Thanks PHV!!!!

Fred