Can't abandon a query without saving

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Somehow, I've set some setting in Access 2003 that won't allow me to abandon
an object without saving it. It also has stopped warning me when I update a
table. What's the option?
 
If you are directly entering data into a form, table, or query in datasheet
view, you will not be prompted for record changes or additions. However you
should be prompted for deletions. If using a form, you could write some code
on an even like On Change or On Dirty event to warn that you have made a
change.

What do you mean by abandoning an object without saving it? You can't say No
at the message box?

Got to Tools, Options, Edit/Find. What do you have for Comfirm? I usually
have all three checked.
 
Sorry, I wasn't clear. I create a new query in design mode, go to close it.
Usually, I'd get "do you want to save this query"... Instead, I get a dialog
box asking me to name it, as if I'd responded to that question in the
affirmative. Choices are "save" or "cancel". If I cancel, I go back to design
mode. If I save, it actually saves it as "query1" or whatever I name it. I
can't tell it "just abandon what I've done..."

In the same db, when I "bang" an action query, it doesn't ask me to
confirm my decision to update or append a bunch of records. It just does it,
no questions asked...

I dunno.
 
AHA! Somewhere in the database is a macro that sets warnings to Off or code
that says:

DoCmd.SetWarnings False

You need to find the macro or code and set warnings back to True after it is
done doing whatever. The code could be in a macro, module, or form. Maybe
even in a report but I doubt it. I'd be looking for code that runs an action
query like deleting, appending, or updating records.
 
Found it...thanx.
--
Jim


Jerry Whittle said:
AHA! Somewhere in the database is a macro that sets warnings to Off or code
that says:

DoCmd.SetWarnings False

You need to find the macro or code and set warnings back to True after it is
done doing whatever. The code could be in a macro, module, or form. Maybe
even in a report but I doubt it. I'd be looking for code that runs an action
query like deleting, appending, or updating records.
Click to expand...
 
Back
Top