Access configuration question

F

Fredrated

I have taken over another programmers Access project (I am using Access XP),
and they have configured it in some way I don't understand.

Whe I work with my usual access programs, I often use the query builder just
to get the SQL i need, then close the query without saving because I am going
to run it in code. When I clck the 'close' button I am normally asked
"Do you want to save changes to the design of query 'query1'?"
I answer 'no' and move on.

In this new project, when i click 'close' I get the prompt
"Save as: Query1" and I have no choice but to save the query, and then I
have to delete it from the query window.

If I click 'close' on new reports or modules, I get no prompt, just
immediate close without save. If I click 'close' on a new table, I get the
same response as with queries.

How do I get back to what I think of as normal behavior? That is, to ask
first if I want to save a new object.

Thanks in advance for your help.

Fred
 
F

Fredrated

I figured out the answer to my question.
In code, the program executes:
DoCmd.SetWarnings False

This changed the way Access worked, setting warnings back to 'true' solved
the problem.

Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top