Andy Lacey
andy at minstersystems.co.uk
Thu Jun 9 10:39:17 CDT 2005
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