docmd setwarnings

[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

 

[PHV]

What about the 3 confirm checkboxes in the Edit/Search tab of the menu Tools -> Options ... window ?

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

 

[AFKAFB]

All three boxes ticked
i've also a piece of code that normally fixes it but not workngi now.
code below:
Public Function setWarningsOn() As Boolean

On Error GoTo ERR_HANDLER

DoCmd.SetWarnings -1

NORMAL_EXIT:

setWarningsOn = True
Exit Function

ERR_HANDLER:

MsgBox Err.Number & ", " & Err.Description
setWarningsOn = False
Exit Function

End Function

 

[SeeThru]

ERR_HANDLER:

MsgBox Err.Number & ", " & Err.Description
setWarningsOn = False
Exit Function

you need the docmd?

Also, I'd make sure any error function turned warnings ON just before exiting, becuase they will stay off until the next setwarningson TRUE is run.

 

[AFKAFB]

hi
i'm unclear with your answer

1. where would i put the docmd
2. can you expalin more about turning warnings on at every error function