Not prompting to save

  • Thread starter Thread starter Andy G
  • Start date Start date
A

Andy G

Is there a new setting in A2003 that prevents Access from prompting the user
to save after making changes to a form/query/report in design mode? All of
the sudden Access doesn't prompt me to save my changes to forms and saves
automatically. This is not good.

Thanks.
 
somewhere earlier did you use the 'SetWarnings False' command? You need to
add the 'SetWarning True' back into the process in order to have the warning
messages back.

HTH
SteveD
 
I don't believe you can set Access not to promt to save a form change in
code. This is more of an Access setting than code.

Any other ideas?
 
Disregard.

I just made a copy of the database and it now prompts me to save form
changes. Weird....
 
Andy G said:
I don't believe you can set Access not to promt to save a form change
in code. This is more of an Access setting than code.
Click to expand...

You're mistaken. If you call DoCmd.SetWarnings False, Access will cease
to prompt for the saving of changes until youi either call
DoCmd.SetWarnings True, or close that instance of Access. Even closing
and reopening the database won't clear that setting, as long as you
don't close the Access application.
 
We are on the same page. I didn't use DoCmd.SetWarnings anywhere in the
code.

I just created a new database and imported all objects. Fixed the saving
problem.
 
Andy G said:
We are on the same page. I didn't use DoCmd.SetWarnings anywhere in
the code.

I just created a new database and imported all objects. Fixed the
saving problem.
Click to expand...

Then it does sound like the problem was probably due to some corruption
of your VB project. I'm glad that fixed it. Still, bear in mind what I
said about how SetWarnings works, in case it comes up in the future.
 
I definitely will. Thanks for the help.



Dirk Goldgar said:
Then it does sound like the problem was probably due to some corruption
of your VB project. I'm glad that fixed it. Still, bear in mind what I
said about how SetWarnings works, in case it comes up in the future.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top