General discussion
March 11, 2005 at 05:43 AM
gsteve

Doesn’t Prompt to Save?

by gsteve . Updated 21 years, 1 month ago

I have started using some VBA modules in my Access databases, and I notice that any time after I have used a VBA command in a database, it stops prompting me to save objects before I close them (it does save the object, but sometimes I don’t want it to).
Example: I have a button on a form with an event tied to the button. I use the button, then go into a query and change a few things in design view. I decide that I don’t want to keep the changes, so I simply close the query. Pow! The query closes, and saves the changes without even asking me.

Is this unavoidable, or is there some setting I can change so that it will always prompt me to save?

Thanks for your help!

This discussion is locked

All Comments