[AccessD] Goodbye Leszynski/Reddick?

 Yes, Charlotte,

But wouldn't Groups help to combine related tables, queries, forms, reports, macros, VBA modules into "components" making selection from hundreds of queries unneeded and also making special prefixing/suffixing of MS Access object names obsolete?

Thank you.

-- Shamil

Sat, 24 Jan 2015 10:41:33 -0800 from Charlotte Foust <charlotte.foust at gmail.com>:
>When you have hundreds of queries and you're working with a list,
>conventions matter. Finding a query using the nav panel search or checking
>your code, the type name helps.
>On Jan 24, 2015 3:38 AM, "Gustav Brock" < gustav at cactus.dk > wrote:
>
>> Hi Shamil
>>
>> I was thinking about just prefixing queries with a simple q since - in
>> newer versions of Access - queries are sorted by type in the navigation
>> pane. That would fit linked views, which often are prefixed with a v.
>> Further, I don't recall I've ever had troubles mixing select and action
>> queries.
>>
>> Will sleep on it.
>>
>> /gustav
>>
>> ________________________________________
>> Fra:  accessd-bounces at databaseadvisors.com <
>>  accessd-bounces at databaseadvisors.com > på vegne af Salakhetdinov Shamil <
>>  mcp2004 at mail.ru >
>> Sendt: 24. januar 2015 12:11
>> Til: Access Developers discussion and problem solving
>> Emne: Re: [AccessD] Goodbye Leszynski/Reddick?
>>
>>  Hi Gustav --
>>
>> Currently I name tables in singular mode and I don't have any
>> prefixes/suffixes used with their names. For queries I still use LRNC
>> prefixes:
>>
>> - qsel
>> - qapp
>> - qupd
>> - qdel
>> ...
>>
>> I have got "addicted" to use the LRNC queries prefixes since I have read
>> Stan Leszynski "MS Access 97 Expert Solutions" book -
>>  http://tinyurl.com/luqfh8h
>>
>> But I'm open to accept any other modern naming conventions where "type"
>> prefixes are not used at all.
>>
>> Thank you.
>>
>> -- Shamil
>>
>>
>> Sat, 24 Jan 2015 09:57:10 +0000 from Gustav Brock < gustav at cactus.dk >:
>> >Hi Shamil
>> >
>> >How do you name tables and queries, please?
>> >
>> >/gustav
>> >
>> >________________________________________
>> >Fra:  accessd-bounces at databaseadvisors.com <
>>  accessd-bounces at databaseadvisors.com > på vegne af Salakhetdinov Shamil <
>>  mcp2004 at mail.ru >
>> >Sendt: 21. januar 2015 16:34
>> >Til: Access Developers discussion and problem solving
>> >Emne: Re: [AccessD] Goodbye Leszynski/Reddick?
>> >
>> > HI Gustav --
>> >
>> >I have also abandoned LRNC in VBA for quite some time now (and I was a
>> strict "LRNC-adept" in 1990-es). The naming conventions I'm using for VBA
>> look similar to yours but for local variables and for functions'/subs'
>> parameters, private subs,functions, properties I'm using lowercase letters
>> in the beginning, and I'm using 'm_"  prefix  for (class) module level
>> variables.
>> >
>> >Thank you.
>> >
>> >-- Shamil
>> --
>> 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