no Save prompt for design changes

[Guest]

I am using access 2k and all of a sudden it won't promt me for any design
changes for anything, Forms, Macros or nothing. I found the following thread
and have followed it to the T. I can find know where in my database where
Warnings are set to true or false. I am lost.
Please help and thank you in advance.

Two possiblities:

One: you have deselected the "Confirm" checkboxes in Tools | Options |
Edit/Find. To fix, reselect these items.

Two: you have run VBA code that turned off the warnings and you didn't turn
them back on.
DoCmd.SetWarnings False
' do some code here
DoCmd.SetWarnings True

To fix "two", go to Immediate Window and type
DoCmd.SetWarnings True
and hit Enter.

To not have "two" return, search your code for places where the warnings are
turned off, and the "turn on" step can be bypassed (often occurs if you have
an error handler that sends the code to a place that doesn't include the
"turn on" step).

 

[Guest]

The first question then is are the changes being saved if you just close the
form, report, etc., without first doing a save? If not, that brings up a
bunch of other questions.

Try this:
Press Ctrl + G keys to bring up the VB window.
Press F2 key to bring up the Object Browser.
Type in "SetWarnings" in the search box and make sure that it says <All
Libraries> above it.
Click on the binoculars button.
You should set the Access DoCmd SetWarnings member. If you see anything
else, check it or them to make sure that SetWarnings is turned off in the
code. As you already read, it's also possible that the procedure has an error
and error trapping is bypassing the SetWarnings off part of the code.

 

[Guest]

Thank you for the reply,
This is wierd, before you were able to reply. I imported all objects to
another .mdb and all is fine now. Even in the backups that were doing the
same thing. hmmmm hope it keeps working. I will let ya know if it does it
again.
Thank you Jerry for your help
Alvin