set warnings

[Guest]

I would like to know if i can turn the usualy database warnings off. i know
the option on the tool bar, but i want to turn it off in the database itself.
i know the set warnings switch in macros and vb, but access reverts back to
on after the routine or the macro. is there anyway to globally do this from
the start of the DB. Thanks for any info.

Chris

 

[Douglas J. Steele]

It's generally not a good idea: sometimes those warnings have useful
information in them!

If you're specifically concerned about the "You're about to delete n
records" type of warnings you get when running action queries, try using the
Execute method of the Database or QueryDef objects, rather than
DoCmd.RunSQL.

I've never heard of Access resetting the warnings setting on its own,
though.

 

[Jeff Boyce]

Chris

I'm with Doug ... it sounds like you have already determined the solution
("turn off warnings"), but I have no idea what problem you are solving.

Regards

Jeff Boyce
<Office/Access MVP>

 

[Steve Schapel]

I've never heard of Access resetting the warnings setting on its own,
though.

If a SetWarnings/No action is used in a macro, the warnings setting
automatically reverts at the conclusion of the macro's execution.
Whereas in a VBA procedure, you must explicitly set the warnings back on
again.