Saving changes

  • Thread starter Sarah at DaVita
  • Start date
S

Sarah at DaVita

When I make changes to this database it seems to save the changes without me
telling it to do so. This is causing many issues. Is there a way to turn
this off? It does not happen in all my database but I cannot find what is
different. Please advise.
 
J

John Spencer

Are you talking about data changes? Or are you talking about changes in the
design of forms, reports, etc.?

If the latter, you have managed to set SetWarnings to False in code and have
not reset it to true. Try typing
Docmd.SetWarnings True
and hitting return in the VBA immediate window. Then try making a minor
change to a form or report and closing the object. See if you get the warning
message then. If so, you need to track down where the DoCmd.SetWarnings False
is happening and make sure you have DoCmd.SetWarnings True execute after you
finish whatever you are doing that you wanted to hide the warnings.

By the way, it is a good idea to DoCmd.SetWarnings True in the error handler
of those procedures.

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