[AccessD] VBA Field Names - Curiosity Question

Jim Dettman jimdettman at verizon.net
Wed Jul 3 08:04:38 CDT 2013


<<And don't get me started on the danger of globals.>>

  I've used globals since day 1 with Access; have never had a problem.

  It's sloppy programmers that write sloppy code that's the issue.  There's
nothing inherently wrong with globals from my viewpoint.   They serve a
purpose and like anything they work fine when used properly.

  It's like the age old admonishment never to use a goto statement.   You
can use goto to your hearts content and still maintain well structured code.
It's a sloppy programmer that ends up with spaghetti code.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Tuesday, July 02, 2013 09:00 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] VBA Field Names - Curiosity Question

Sorry Brad, but adherence to disciplined naming conventions make a HUGE
difference towards ease of maintenance.

Especially critical : Use of Globals !!
And don't get me started on the danger of globals.

> Examples -
> 01 Part-Number   PICTURE X(30).
> 01 Part-Cost    Comp-3    PICTURE 9(05).
>
>
> In VBA examples, I see most people using prefixes such as Str, Lng,
> Dat,
> Etc.
>
> I have never quite understood why people do this when working with VBA
> while I believe that very few people did this in the COBOL realm.
>
> In COBOL we would simply look at the Picture clause in the field name
> definition.  This would be the equivalent of looking at the DIM
> statement.
>
> Again, this is just a curiosity question.
>
> Thanks,
> Brad


-- 
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