Prompt for Save?

[PeterM]

I have AC2003. It has recently stopped prompting me to save changes when I
change a form or a report. It does save the changes without prompting me if
I want to save them or not.

I've looked everywhere to find an option that controls this and can't find
it. Is there such an option?

Thanks!

 

[John Spencer]

Check that you don't have warnings turned off.

You can turn them back on with
Docmd.SetWarnings True

Also, check under Tools: Options Edit/Find tab and make sure that you have
Confirm checked.

If you have VBA code or a MACRO that changes SetWarnings to False, make sure
you change it back again when the code finishes (you need to do this even if
the code errors). You could also create a small macro that turns warning back
on, since you can't trap errors in macros.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[PeterM]

thanks for the reply, confirmations were turned on, but there was a couple of
setwarnings that I didn't reset.