Thanks Rod.
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 borninfulton
Sent: Wednesday, October 24, 2012 8:10 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: global variable persistence
Unless I'm seriously mistaken, when you stop your VBA apps from running in MS Access, then the data in global variables aren't guarenteed to persist. They only retain their values, so long as the VBA app is running.
Rod
--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> 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.
>
------------------------------------
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 (5) |
Tidak ada komentar:
Posting Komentar