no prompt to save objects

T

Tony

I have had Access2003 for a long time and all of a sudden, it is not
prompting me to save my forms when I close them. It seems to be auto-saving
them, but I don't know what changed its behavior. Can anyone tell me so I
can reset it back to prompting me before saving?
--Tony
 
K

Ken Snell [MVP]

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).
 
T

Tony

Thanks Ken... it was number 2.


Ken Snell said:
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).
Click to expand...
 
A

Alvin

I use Accvess 2000 One of my databases does the same thin.
I Have tried both steps with no result. Is there anything else I can look for?
Alvin
 
Top