No Save Prompt Issue

  • Thread starter Thread starter Barry Fuller
  • Start date Start date
B

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
 
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.
 
-----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.
Click to expand...
Excellent. I did find some code where that was the case.
Thank you very much.
 
-----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.
Click to expand...
I was able to replicate the problem. You were correct, I
added the necessary code and it now works fine.
Thanks again!
Barry
 
Back
Top