Link to home
Start Free TrialLog in
Avatar of pwdells
pwdellsFlag for United States of America

asked on

Why is MS Access requiring me to save queries?

Hi Experts,

It seems like it has been just recently, that I am now required to save every query that I make during production in the Design View.  This is really annoying because sometimes things are just for a quick temp look up.  So now, I have to give the query a bogus name, save it, then delete it.

Thanks,

Wendee
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Not quite following?
Are you making design changes?
Are you right click and filtering/sorting when in datasheet view? If so, Access considers those 'design changes'.

Also ... have you rebooted your system since this started (seriously) ?

mx
Avatar of pwdells

ASKER

If I create a query in Design View and go to close the query, I have 2 choices (1) Save the query or (2) go back to Design View of the query.  I cannot close it without saving it.  Most of the time, I don't ever want to save the queries, they are just quick lookups, nothing I would every keep for future use.

I reboot my computer 2 times a day because I go between work and home with it.  So, yes, definitely I reboot.  :-)

Wendee

 That's the way it works for me...

JimD.
Just let them be saved as Query1, Query2, etc., and clean them up every once in a while.
Avatar of pwdells

ASKER

That's weird.  I feel like I've been able to close (discard) a query upon closing, if I wish not to save it.

open the VBA window, type

docmd.SetWarnings true

and hit enter

now try creating a query and close
open the VBA window, type

docmd.SetWarnings true

in the immediate window and hit enter

now try creating a query and close
"I have 2 choices (1) Save the query or (2) go back to Design View of the query. "
Can you post a screen shot of this ?

What you should be getting is in the screen shot below ... is that Not what you are getting ?

mx
Capture1.gif
he will get that dialog box after running the codes posted at http:#a35486256
Avatar of pwdells

ASKER

I am NOT getting that.  Attached is my view.
SaveProblem.bmp
pwdells, are reading my posts?
pwdells, are you reading my posts?
If Set Warnings was Off, there would be No prompt whatsoever.

mx
Avatar of pwdells

ASKER

Cap: That does not work.
OK ... looking at your image, I recall this same thing happened a while back ... and it seems the answer was to reinstall Access (or Office).  

mx
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pwdells

ASKER

I will try that.
pwdells:
IF ... SetWarnings have been left set to False somewhere ... you would received *not* prompt whatsoever.  It would have automatically Save your query as is when click in the X button on the query.  If your system was working normally now, you could easily test this.

mx
Avatar of pwdells

ASKER

As soon as Capricorn explained that the "DoCmd.SetWarnings (false)" had to be paired with "DoCmd.SetWarnings (true)" in each sub routine that I have an action query, it made complete sense.  Before that, it did not work, when I tried just "DoCmd.SetWarnings (true)".
so you learned something New!!!
Avatar of pwdells

ASKER

Indeed.  Everyday, I do!  :0)