Max Wanadoo
max.wanadoo at gmail.com
Wed Sep 24 02:18:26 CDT 2008
Me too. I could never figure out AND remember if it was the one I clicked on that was saved or the ones that I didn't click on and if I got it wrong, I lost work. So for me, same as Robert, I save the lot! Call me a coward but there we have it! Max On Tue, Sep 23, 2008 at 9:02 PM, Robert <robert at servicexp.com> wrote: > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >