Prompt to save changes to a query

[Guest]

This seems so simple but.... as usual.

My database no longer asks me to save changes made to an existing query.
For example; If I go into an Append query to check the output by making it a
Select and close it without changing it back, it saves it as is and doesn't
prompt me if I would like to keep the changes before closing - It used to
prompt me when I closed it.

I don't remember how this came about but I looked through the Options screen
and the only confirm options is for deleting an object or running an action
query.

Does anyone know how to make it so I can close a query and have it not
automatically save unless I choose too? Or have it prompt me when I close it
like it used to do?

 

[Bill Mosca, MS Access MVP]

Tim

I've had that happen a few times. Compacting seemed to fix it.

 

[aaron.kempf]

man
how about 'setwarnings on'

ROFL

Docmd.SetWarnings ON or TRUE or whatever; it's also an option under
tools, options

MDB is flaky as all hell.. but not THAT flaky

-Aaron


PS - for the record; with SQL 2005 you can have DDL triggers; so you
can DO STUFF when someone changes a query. for example; you can record
who changed a query; and either approve or reject the change.

 

[Guest]

Hi TimT

Somewhere along the line warnings have been turned off and not back on again.

To turn them back on go to the modules tab - Click New - Press Ctrl-G and in
the lower window type

DoCmd.SetWarnings(True)

and press enter then close the debug window and the new module and
everything should be back to normal.

Hope this helps
Regards

Andy Hull

 

[Guest]

Of course!!!!
Thank you!!