No Save Prompt Issue

[Barry Fuller]

Hello all.
I am having an issue where Access stops prompting me with
the option to save or not save when I close forms, reports
etc. It will prompt me initially, but I as I continue to
work (flipping between form mode, design mode and code),
it stops prompting me and just automatically saves the
changes. I saw a Knowledge Base article that was similar,
but not exact (It's resolution was to install SR1/SR1a).
A reboot of of the machine does fix it temporarily, but
the problem occurs again shortly after reboot.
It sounds like a memory leakage issue but I am not sure.
Details of the machine:
3.0 Ghtz P4
2.0+ Gig of Ram
2.0+ Gig of virtual mem
Service Pack 3
Access 2000
OS Win 2000

 

[Joe Fallon]

Somewhere in your code you are using:
DoCmd.SetWarnings False

but then you fail to use:
DoCmd.SetWarnings True

As you work on the app the code runs and your prompting stops.

 

[Barry Fuller]

-----Original Message-----
Somewhere in your code you are using:
DoCmd.SetWarnings False

but then you fail to use:
DoCmd.SetWarnings True

As you work on the app the code runs and your prompting stops.

Excellent. I did find some code where that was the case.
Thank you very much.