Set Warnings

A

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
 
A

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
 
S

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.
 
Top