Robert
robert at servicexp.com
Tue Sep 23 15:02:03 CDT 2008
Well, I have experienced it many times over the last 8 years, from 2002 to 2007. I now simply allow the save to take place on all the objects, it's just not worth the risk, in my opinion. 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 3:52 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2002 - Another way to lose your work If you mean the vaporizing of work done in other objects then I'm not sure I agree. I have often done what I described, save just a subset of the list of changed objects, and then continued to work on the other, still unchanged ones. This is the first time I've ever lost anything when I made that choice. That was true in Access 97 and Access 2002 (which I'm using right now). ???? Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: Tuesday, September 23, 2008 3:43 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2002 - Another way to lose your work 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 -- 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