Rocky Smolin
rockysmolin at bchacc.com
Sat Jan 24 23:01:57 CST 2015
I use the prefix to tell me what kind of object I'm working with - recordset, query, text box, combo box, report, form, etc. r -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav Sent: Saturday, January 24, 2015 7:58 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Goodbye Leszynski/Reddick? Hey All Why not?? For Queries their names become CustAdd CustDel CustEdit CustFind It is intuitive, sorry I do not get the prefixes/suffixes. Maybe after all these years I have been missing the point. Yes Gustav this list is addictive like the old American Television show "Cheers". Tony Septav Nanaimo, BC Canada -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov Shamil Sent: January-24-15 5:11 AM To: Access Developers discussion and problem solving Subject: 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 ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2015.0.5645 / Virus Database: 4273/8984 - Release Date: 01/23/15 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com