Jim Hewson
JHewson at karta.com
Thu Jun 9 12:46:04 CDT 2005
Good point! I'll do it. Thanks all. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Thursday, June 09, 2005 11:51 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Close object without saving And for that reason, the Docmd.SetWarnings True should be placed immediately in front of the (ONLY) line of code that says Exit sub. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Thursday, June 09, 2005 11:39 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Close object without saving Jim I suspect that your program somewhere has done a Docmd.SetWarnings False and not set it True again. So I'd a) put Docmd.Setwarnings True at the start of your MDB to get it sorted, but b) try to find the offending code cos it's going to keep happening otherwise. One thought is that the code may be setting it False, falling into an error and the error handler doesn't set it True again. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: Access Developers discussion and problem solving <accessd at databaseadvisors.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Subject: RE: [AccessD] Close object without saving Date: 09/06/05 15:27 > > 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 > > > > > ________________________________________________ Message sent using UebiMiau 2.7.2 -- 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