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 forces you to save query
I am trying to solve a problem that I have noticed in the
past few days. I typically create a lot of ad-hoc query's, obtain the results, and then close the query without saving. Lately this is not an option, when I click the X button in the corner of the query a "Save As" box comes up and does not allow me to close without saving. Any thoughts? |
#2
|
|||
|
|||
"Chris" wrote in message
I am trying to solve a problem that I have noticed in the past few days. I typically create a lot of ad-hoc query's, obtain the results, and then close the query without saving. Lately this is not an option, when I click the X button in the corner of the query a "Save As" box comes up and does not allow me to close without saving. Any thoughts? I suspect that somewhere in the database there is code that uses the DoCmd.SetWarnings False statement to turn off the automatic warnings in order to do some data manipulation without warning the user. But then it fails to turn warnings back on again with DoCmd.SetWarnings True So you are left in a state in which Access won't display its "Do you want to save ...?" warning prompt, but just assumes you want to do it. Wherever you turn warnings off, you must exercise care to ensure there's no way code can exit your procedure, even if an error occurs, without turning warnings back on again. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
EXISTS reserved word in FROM clause | Stephanie Doherty | Running & Setting Up Queries | 6 | July 21st, 2004 01:15 AM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Retrieving Count of rows returned from MS Access Query | Don | General Discussion | 2 | June 27th, 2004 07:54 PM |