Randall R Anthony
RRANTHON at sentara.com
Thu Jun 9 11:20:59 CDT 2005
Another way, which I don't recommend (but found out the hard way) is to go to Tools >> Options >> Edit/Find tab and uncheck Record Changes, Document Deletions and Action Queries check boxes. >>> Lambert.Heenan at aig.com 6/9/2005 11:54:13 AM >>> What you need is Docmd.SetWarnings True Which you can type in the immediate window and hit enter. This setting is specific to each database, and it defaults to True (On). Normally this code is used, for example, just before running an update query, and then the warnings are turned back on with Docmd.SetWarnings True. I suspect that you have turned warnings off at some point in your code and then did not turn them back on. This setting persists with the database even when it is closed and started up again. A common cause of the problem is where warnings are turned off in code, but then a runtime error happened and they were never turned back on. That is why I always ensure that routines that turn off the warnings have an error handler that turns them back on. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Thursday, June 09, 2005 11:27 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Close object without saving No, I found that. What I'm looking for is the dialog box and asks if I want to save the query, form, etc. Instead it automatically saves. Thanks Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Randall R Anthony Sent: Thursday, June 09, 2005 10:16 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Close object without saving Is this what you're looking for? Added to the end of the DoCmd. statement. , acSaveNo -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com