[AccessD] Goodbye Leszynski/Reddick?

Charlotte Foust charlotte.foust at gmail.com
Sat Jan 24 12:41:33 CST 2015


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
>


More information about the AccessD mailing list