Graham, This is good to know. Thanks so much. Now I know where to spend my time and how to fix my environment so that I can move on.
Have a wonderful day.
Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Graham Mandeno
Sent: Tuesday, October 23, 2012 4:32 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] global variable persistence
Hi Liz
If, while debugging, you click the "Reset" button or the "End" button, all your code will be set to its initial state. That means that all variables, including global ones, will revert to their values at the time they were declared.
If the value of booAccess was False before the reset, then it will still be False after, so perhaps that is why you have not noticed a problem with that one?
-- Graham
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Wednesday, 24 October 2012 12:15
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] global variable persistence
Pros, is there anything I'm missing with a particular global variable not persisting? I'm debugging and working through errors and then when I fire up my testing again, the variable has lost its value.
This is in the declarations section of a module:
Option Compare Database
Option Explicit
Global booAccess As Boolean
Global strWho As String
The global booAccess is in a previously released version of the database and I have had no reports or problems with that one persisting, so I'm wondering if it's because I get errors and there is some type of flush.
?
Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com<http://www.beaerospace.com>
This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar