[AccessD] Access 2002 - Another way to lose your work

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





More information about the AccessD mailing list