Prompt to save query

[Maria L]

I am working with the database that does not prompt you
to save a query. If you make changes to an existing
query it will save without a prompt. If you create a new
query you won't be asked if you want to save the query
you will only be prompted to name it.
Any suggestions on how to change this?

 

[Ken Snell [MVP]]

Sounds as if someone turned of SetWarnings via code or macro.

Open Immediate Window in Visual Basic Editor. Type this next line in that
window and the press Enter:

DoCmd.SetWarnings True



Whenever SetWarnings is turned off in code, always be sure to put the "turn
it back on" step in error handlers so that, if an error bypasses where you
have put it in the code, it'll still get turned back on.