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