default settings for "save" and "save as"

[sawilliams]

I must have changed some default setting (Access 2003) but "most" of the time now when I am closing a form to which I have made changes, I don't get the "save" dialog box. The form is saved regardless of whether I want to save changes or not. And, now today, when I close a query that I don't want to save, I only get a "save as" dialog box and I'm forced to save it as something and then delete it.

I'm sure this is something really simple but any suggestion would be greatly appreciated.

 

[GingerR]

you have turned your warnings off some place along the way, and not turned them back on (maybe in some form code that crashed or something?)

anyhow, i always have a code module:

Function Admin()
 docmd.setwarnings True
 docmd.echo false
 docmd.hourglass false
End Function

that i run now and then in these instances.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[PHV]

GingerR, I'd replace this:
docmd.echo false
with this !
DoCmd.Echo True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sawilliams]

Thanks GingerR. I do have setwarnings to false in spots. I should go back and make sure the are turned back on. And I will make use of the code you kindly provided. But would "setwarnings False" cause my query "save" to change to only "save as"?

 

[GingerR]

Oops PHV, you're right. I didn't copy it from one of my db's, I just made it up here Thanks.

sawilliams re: query question - it'll behave normally, i.e. "Do you want to save changes?"

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[sawilliams]

Thanks GingerR and PHV. As usual this is the best site for answers. You guys are great!