[AccessD] Goodbye Leszynski/Reddick?

What helps me even more are verbose names. Like this one I just did - it's a
one shot but gives you the idea:

qrySetDoneToZeroForSubcontractPartsWhereReleasedIsZero

In 2003 you can see those names in the database container.  In 2010 you've
got the nav pane which you can stretch but then you lose the open object's
real estate.

It wasn't broke.  But they fixed it good. :(

r 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Saturday, January 24, 2015 10:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Goodbye Leszynski/Reddick?

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