John Colby
jwcolby at ColbyConsulting.com
Thu Mar 2 18:47:28 CST 2006
>Using Dot to refer to properties is known to cause weirdnesses. Ooops. Using Dot to refer to Objects can cause weirdnesses. Sorry for the confusion. I can think of at least one exception (kind of) however. To refer to a control on a subform, the syntax is me!SubformControl.Subform!Control. In this case I think that .Subform is a PROPERTY of the subformControl which returns a pointer to an object (the actual loaded subform). So even here Dot is the correct syntax. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Thursday, March 02, 2006 6:55 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Table naming conventions LOL, because it is the wrong syntax and can cause the vba interpreter to get confused and do stupid things. In the early days of Access, me.object was the accepted syntax. Sometime around A97 Microsoft switched to the ! As the "accepted" syntax. Dot is for properties, Bang is for objects. Using Dot to refer to properties is known to cause weirdnesses. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Conklin Sent: Thursday, March 02, 2006 5:02 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Table naming conventions 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 -- 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