[AccessD] VBA Field Names - Curiosity Question

Arthur gets my vote. Been using suffixes for years.

Lambert

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

That's OK, Arthur, I forgive you.  I had to work with suffixes in .Net and discovered their distinct drawback, having to read the entire name to determine what the object is.  Granted, that is somewhat offset by grouping capabilities in the latest versions of Access, but navigation bar group swapping is something I do NOT enjoy.

Charlotte

On Tue, Jul 2, 2013 at 9:24 AM, Arthur Fuller <fuller.artful at gmail.com>wrote:

> I know I'm going to be busted for this but I need to say it anyway. I 
> think that Hungarian prefixes are Wrong. I am devoted to the school of 
> Hungarian suffixes, which means:
>
> Customers_All_qs ' that means Query Select Customers_One_qs ' that 
> means Query Select with an ID provided Customers_Insert ' duh.
> Customers_Delete ' duh
>
> The point of doing Hungarian suffixes is to group the objects by 
> entity-name. Prefixes do not achieve this and the more involved the 
> app the more difficult approaching it becomes. That's why I invented 
> and switched to Hungarian suffix notation. If you're dealing with 100 
> or more tables, Hungarian prefix is going to cost you 10 or maybe 20 
> hours per week, looking for the object of interest.
>
> So, in honour and respect for the man who wrote Excel, I'll stick with 
> the Hungarian part of the nomenclature, but I with to call it 
> Hungarian suffix rather than prefix. And I think that I am right in 
> this small revision of the Bible.
>
> A.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com