don't want to save the query

[VilMarci]

Hi,

I found a bug that sometimes Access query builder does not allow to simply
discard my query build without saving that query.
If I close the builder, normally I should get a window asking if I'd like to
save the query or not. Sometimes (very often), only a save/cancel window
pops up.

Is there any way to solve it?

Thanks,
Marton

 

[Guest]

I'm trying to solve the same issue. I saw your post and thought I'd add my
two cents. As best I can tell, this seems to occur if certain forms are open
or were previously opened in the current Access session. Specifically, if I
open an Access file and create a new query, including adding tables, columns
and previewing in datasheet view, I can still close without saving. However,
if I open a form ([frm_FORM_NAME]) and even subsequently close the form, I am
unable to start creating a new query and decide to close without saving. The
issue is common with complex forms with significant VBA code. I've
experimented with newly created, basic forms without the same result. I
presume the issue is a result of poorly written VBA code, possibly leaving a
recordset open, etc. Does anyone know the exact cause?

Thanks,
Erich

 

[Guest]

I just found a solution...not sure it is the only solution, or if it will
work for you, but it solved my problem. Within the form VBA module, someone
inserted a command (docmd.setwarnings 0) without a subsequent command
(docmd.setwarnings -1). Apparently, among other things, this controls
whether the user has the option to close a new query without saving it first.

Hope this helps,
Erich