[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