Andy Lacey
andy at minstersystems.co.uk
Wed Dec 31 04:14:38 CST 2003
Doug I think you'll find that SetWarnings been set off by a line of code or a macro, and not been set on again. Just issue a "docmd.SetWarnings true" in the immediate window and I suspect the warnings will reappear. The issue that'll leave is then to find the code which turns warnings off but fails to put them back on. One possibility is that a routine errors after setting warnings off and the error handling doesn't set them back on. Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy > Sent: 30 December 2003 23:45 > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Probably simple question re Access 2002 > > > Dear list, > > This is probably a very basic question, but something I have > not run into before. I have an Access 2000 database that a > potential client sent me to look at. I notice that when I > open an object, e.g., report in design view, and change > something in this database I am not asked if I want to save > the changes when I close it. In all the other databases that > I have developed on this machine I am given the option to > save or not save when I close an object that I have fiddled > with. I have looked to see if the db/tools/options settings > are set differently but can not see where to set this > behavior. Can anyone tell me if this can be set and where to > do it? I like to have the option of saving or not saving > changes as I will often experiment with changes and not want > to make them permanent. > > Thanks in advance and have a Happy New Year. > > Doug > > Douglas Murphy > Murphy's Creativity > (619) 334-5121 > doug at murphyscreativity.com > www.murphyscreativity.com > > > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > >