Access 2000 doesn't ask to save design changes anymore. Why?

G

Guest

I have searched to no avail and I have no clue why MS Access 2000 has stopped
prompting me to save any design changes made to forms, reports, tables ect;
Please any help is greatly appreciated.
 
J

Jason Lepack

Your Warnings are turned off.

Somewhere in your database there is the line "docmd.setwarnings false"
that is not later followed by "docmd.setwarnings true". Easiest way
to fix this is to create a new module and put these functions in it:

Public Sub turnoff()
DoCmd.SetWarnings False
End Sub

Public Sub turnon()
DoCmd.SetWarnings True
End Sub

You can execute turnon() to turn warnings on an watch your problem
disappear. You can also reacreate your problem by using turnoff()

I suggest you inspect your code to find out where you should be
turning warnings back on.

Cheers,
Jason Lepack
 
G

Guest

I haven't changed any code for quite some time. If I reinstall Access it goes
away for a while, Sometimes for months and then it's back. It effects all
access Db's even new ones.
 
J

Jason Lepack

Did you even try what I mentioned?

I haven't changed any code for quite some time. If I reinstall Access it goes
away for a while, Sometimes for months and then it's back. It effects all
access Db's even new ones.
 
G

Guest

Yes,
I searched every module, form,query and everything for "SetWarnings" so I
could locate it and it isn't anywhere in the db.
I'm stumped. Thank you for your pateince.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top