Way To Surpress warnings?

[mcl]

Is there a way when running a macro (or just a query) where you can stop all
the stupid warnings.
I link via ODBC to our oracle database at work.
I use queries to pull a small subset of data down to my local machine using
a make table query.
All those stupid warning are just a pain and totally unnecessary. Warnings
about going to make a table, delete a table...blah...blah..blah.
Yes I wouldn't be using a make table query of it didn't want it to do that.
Plus I force some elements to double precision rather than let access guess
and there some cases of missing data.
Of course access once again gives a totally unnecessary dialog box and then
does exactly what it needs to do, leave them as nulls.
So is there a way to surpress all that garbage?

 

[John Vinson]

So is there a way to surpress all that garbage?

Yes.

Setwarnings False

before running the queries; be sure to

Setwarnings True

afterward or you'll turn off all warning messages, even ones you want
to see.

John W. Vinson[MVP]

 

[Duane Hookom]

You can execute code before running the action queries:
DoCmd.SetWarnings False
then after running the queries
DoCmd.SetWarnings True