Steve Conklin
developer at ultradnt.com
Thu Mar 2 16:01:39 CST 2006
Reason(s)? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Thursday, March 02, 2006 4:22 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Table naming conventions Me. Should NEVER be used to refer to controls. Dot . Should only refer to properties. Bang ! Should be used to refer to controls and objects. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Thursday, March 02, 2006 1:32 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Table naming conventions On a related note, does everyone use/not use Me. when referring to a control in code? Any advantage other than the auto-fill to using Me.? TIA Rocky Charlotte Foust wrote: > You use suffixes for ease of navigation. I prefer prefixes for > grouping by types of objects. Different strokes. > > Charlotte > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, > Lambert > Sent: Thursday, March 02, 2006 6:16 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Table naming conventions > > > Not read all this, but one point I want to make is "why are people > obsessed with PREFIXES?" > > I use the "_tbl" SUFFIX in my table names. Why? So that when I sort > the list of tables I can use the initial letter of the table name to > quickly jump to it using the keyboard. If they all begin with "tbl" > you cannot do that. Simple. :-) > > Lambert > > -- 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