If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 not promting to save changes to queries
I open a query in design view in Access and make some modifications.
When I close the query, it does not prompt me to save the changes. It does save the changes, but what if I don't want them saved? Is there a setting somewhere that I don't know about?\ rh |
#2
|
|||
|
|||
Chances are good that you've run some code that turned off the warnings
(DoCmd.SetWarnings False). Open Visual Basic Editor, make Immediate Window visible, and run this command in that window: DoCmd.SetWarnings True That should fix it for you. Anytime code turns warnings off, be sure to always turn them back on; especially if you have error handler code -- always put the DoCmd.SetWarnings True step in the error handler if you've turned warnings off in the procedure. -- Ken Snell MS ACCESS MVP "r0adh0g" wrote in message ... I open a query in design view in Access and make some modifications. When I close the query, it does not prompt me to save the changes. It does save the changes, but what if I don't want them saved? Is there a setting somewhere that I don't know about?\ rh |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Save and Save as buttons on word 2003 | vincent | General Discussion | 3 | June 14th, 2004 03:46 PM |
Problem running Access 2003 and Access 2000 apps on same machine. | Rathtap | General Discussion | 3 | June 13th, 2004 01:30 AM |
Access 2003 --> 2002 compatibility | Ken | General Discussion | 2 | June 4th, 2004 07:08 PM |
Access 2003 less functional than Access 97? | George Hester | General Discussion | 2 | June 4th, 2004 04:53 PM |
Two versions again-language issue | Otto | Setup, Installing & Configuration | 3 | May 28th, 2004 04:57 AM |