Share via

Auto saving queries on exit

Anonymous
2010-12-16T17:41:55+00:00

When I exit a query, I am not given the option to save, access 2003 just saves any changes I've made.  Is there a setting I need to change to be allowed to exit without saving?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-12-16T17:45:38+00:00

No, no setting per se but at some point you may have used DoCmd.SetWarnings False and not turned it back on.  So, go to the VBA Window and in the Immediate Window type this exactly:

?DoCmd.SetWarnings True

and hit enter.

Then see if it now confirms for you.  If it works, you should try to find where you are setting the warnings to false and make sure they are turned on (that includes error handlers).

Bob Larson, Former Access MVP (2008-2010)

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-12-16T18:04:01+00:00

    Found it.  Thanks for your help.

    Was this answer helpful?

    0 comments