pwdells
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
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
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
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.
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
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
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
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
ASKER
I am NOT getting that. Attached is my view.
SaveProblem.bmp
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
mx
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
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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!!!
ASKER
Indeed. Everyday, I do! :0)
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