save issue

B

Brian C

When I create a query and attempt to exit it, I am not getting the Save
Dialouge box. It only gives me the option to save with a new name. the same
goes when I edit a query. It automatically saves it without the option to
overwirite.

This only seems to be occuring in Access.

Any suggestions.
 
J

Jerry Whittle

Do you mean that the query, form, or report just closes without prompting for
saves when you have made a change to the design of the query? If so somewhere
in code or a macro the warnings have been turned off to do a task like an
append query, but someone forgot to turn them back on. Check all your macros
for a Set Warnings line.

It could also be in code. To check do the following:
Press Ctrl + G keys to bring up the VB window.
Press F2 key to bring up the Object Browser.
Type in "SetWarnings" in the search box and make sure that it says <All
Libraries> above it.
Click on the binoculars button.
You should set the Access DoCmd SetWarnings member. If you see anything
else, check it or them to make sure that SetWarnings is turned off in the
code. It's also possible that the procedure has an error and error trapping
is bypassing the SetWarnings off part of the code.
 
Top