[AccessD] Global Variable

MartyConnelly martyconnelly at shaw.ca
Mon May 16 12:20:05 CDT 2005


Be aware of the fact that global variables lose their values after 
untrapped runtime errors.
In a runtime Access environment this is no problem (Access crashes... 
and has to be restarted)
In a full Access environment I have seen unpredictable result swith this.

You may want to get at them from a lookup table or set in a class.

Gustav Brock wrote:

>Hi John
>
>You may like or prefer or need, or not, a global variable - that's up
>to everyone to decide for him/herself - but they are not "bad practice",
>not even in general. You may write clumsy code using globals, but not
>using them gives no guarantee for nice code.
>
>/gustav
>
>  
>
>>>>jwcolby at colbyconsulting.com 05/16 5:00 pm >>>
>>>>        
>>>>
>To dimension a global variable just go to the header of any module and
>type
>in 
>
>Global MyVar as SomeVarType
>
>That's all there is to it, you can now reference the variable from any
>code
>in the project.  Don't get carried away with them, they are considered
>bad
>practice in general.
>
>John W. Colby
>www.ColbyConsulting.com 
>
>Contribute your unused CPU cycles to a good cause:
>http://folding.stanford.edu/ 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com 
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
>Sent: Monday, May 16, 2005 10:54 AM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Global Variable
>
>
>Hi All,
>
>I am using a code example, from Microsoft, that allows me to print a
>constant number of lines on a report. The code example uses a variable
>that
>is defined as Global. "Global TotCount As Integer"
>
>What's the deal with Global? I can't find it defined anywhere.
>
>TIA!
>JR
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list