[AccessD] Goodbye Leszynski/Reddick?

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