Robert
robert at servicexp.com
Tue Sep 23 14:42:34 CDT 2008
I believe that it's a bug from way back, and is still present in Access 2007 WBR ~Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Tuesday, September 23, 2008 2:57 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2002 - Another way to lose your work No good I'm afraid. Directly after opening an MDB file ? SetWarnings returned a blank line. If I then type DoCmd.SetWarnings False, then ? SetWarnings still returns a blank line. If I type DoCmd.SetWarnings True, then ? SetWarnings still returns a blank line. As for my lost work, the fact that the list of changed objects opened up when I hit the save button tells me that SetWarnings was True, but I still cannot figure out why the one object (a form) got saved, and all the other changes (to code modules) got blown away. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Tuesday, September 23, 2008 2:15 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2002 - Another way to lose your work You can go into the immediate window and type ? SetWarnings should return blank/nothing or False On Tue, Sep 23, 2008 at 10:02 AM, Heenan, Lambert <Lambert.Heenan at aig.com>wrote: > Cross posted to Access-L and Access-D > > Ever seen this happen? I just lost 90 minutes of work this morning... > > The scenario was I had a couple of modules open, and a form module, > and another from. Had a few bookmarks set to a could jump between > modules/functions. > > After working on one of the forms I hit the Save button and I got the > usual listbox showing the altered objects in my project. I deselected > all the objects other than the form I wanted to save at that point and > then when I returned to an open module the first thing I noticed was > that I had no bookmarks set anymore. The next thing I noticed was that > all the code I had just written had vaporized. Aaargghh!!! > > The only think I can think of that might cause this is that > SetWarnings may have been set to False, but why, when I did not close > any of the altered objects, did my changes get blown away? > > Any way to tell in code if SetWarnings = False? > > Lambert > -- > 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