Cannot Close Query Without Saving

[Justin]

Does anyone know why MS-Access won't allow you to close a query without
saving? That was a great feature of earlier versions. Now, whenever I run a
temp query, I cannot just close without saving. It forces you to enter a
name. Thanks.

 

[John Spencer]

Can't say for 2007, but in the past when i've seen this behavior the Confirm
functions on the Options page have been unchecked or some code has executed to
set Warnings off and they have never been switched back on

In VBA
DoCmd.SetWarnings False

In a macro
Action: SetWarnings
Warnings On: No


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Bryan in Bakersfield]

It sounds like your warnings are off. Rather than ask Are You Sure, Access
is assuming that you are and trying to save the query.

Try going to the Immediate Window (press CTRL and G at the same time) and
type:

docmd.SetWarnings true

and hit <ENTER> to run the command.

It should now prompt you when you hit close a query.

Unless you set it yourself, there must be some code that disables the
warnings because I believe these warnings are normally enabled.


Bryan