Set Warnings

[AFKAFB]

Hi
My access database seens to have the Set Warnings command turned off.
Whenever i run queries it does not show the error command.
All my macros use the set warnings command to no and yes at the end of
the macro but for some reason its turned off.
Any ideas
AFKAFB

 

[RobFMS]

Determine if there is any code that is being executed that sets the
SetWarnings True/False and make sure everything is set appropriately.
Perform a search on the entire DB.

Is it possible there is an error that is occuring and the macros are not
getting to the SetWarnings True?

Depending on the number of macros you have, you may want to convert them to
code and then scan for the SetWarnings True/False pair.

--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[AFKAFB]

Hi
I've checked all the code and macros as suggested and all setwarnings
are set to true/yes.
Also the Action Query box is ticked on Tools | Options.
This is really confusing me.
afkafb

 

[Steve Schapel]

AFKAFB,

I don't know what the problem can be. But I don't think the macros can
be implicated... it is not necessary to use a SetWarnings/Yes action in
a macro, as the SetWarnings is automatically reverted to On at the end
af the macro anyway.