Warnings Disappear

[JACKSON]

Recently

I have noticed that the "warnings" in my access 200o database no longer pop up. As example, if I went to delete a table or record, I used to get a pop up warning from MS Access asking for confirmation. Now the record just deletes without a warning. This seems to be happening with other things too.

Any thoughts ???

Thanks

Jackson

 

[KeithG]

docmd.Setwarnings True

The above code will turn your warning back on for you.

 

[neileg]

Go to Tools\Options\Edit/Find and check your Confirm settings.

 

[boblarson]

you can do what neileg suggested, but more than likely it is as KeithG alluded to. Somewhere you might have used a "DoCmd.SetWarnings(False)" command and didn't turn them back on.

I've run into this personally and what I will do is go add a sub in one of my modules that has this:

Public Sub TurnWarningsOn()
DoCmd.SetWarnings(True)
End Sub

and then I just run it from the IDE window. So, if I ever get that happening again, I just go there and run it and it restores it.

What can happen is that you have a SetWarnings(False) in there AND have a SetWarnings(True), but in between you have an error and break on it and then it doesn't get to the SetWarnings(True) part. Another way to make sure that it gets reset is to put the above code in your error handling whenever you have a place where you set the warnings to false.