Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving my options

Status
Not open for further replies.

ind

Programmer
Mar 9, 2000
121
US
I want to turn off the confirm warning for deletions of records, action queries and documents inside my database. Everytime I turn them off and then close and re-open my database, the settings are back on. How can I turn them off, where they will stay off.<br><br><br>Thanks
 
You might have luck with putting this in your autoexec macro.
 
do you happen to be running a network version of Access?&nbsp;&nbsp;it may be that if you are, the default's for the network reappear upon your opening. I know on local installs, when you change it under the Tools=&gt;Options menu, they stay changed.<br><br>Like HIM said, try putting in an Macro named AutoExec that uses the SetWarnings command, set the value to No.<br><br>but be forewarned, there's nothing worse than working in a database that has the error messages turned off and accidentally letting your finger slip to that Delete key (I know from my own arrogant experience - i thought i didn't need delete warnings).&nbsp;&nbsp;Try recreating a form, after you spend half a day trying to figure out what form you deleted. I highly suggest just setting the warnings to False for specific instances where you don't want to see the messages, not the entire database.<br>just my cent and a half... my opinion's not worth two cents. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top