Charlotte Foust
cfoust at infostatsystems.com
Fri Mar 3 12:30:24 CST 2006
Yes, I understand that, Lambert. But when you create a custom collection object and you refer to the members of that collection, you use the dot operator, not the bang. I didn't have a handy example, so I fell back on what I posted to illustrate. Arrays are much easier to work with, but collections have a charm all their own. ;o} Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, March 03, 2006 8:36 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Table naming conventions " Me.Controls" is not referring to the members of the Controls collection. It is referring to the Controls collection itself, which is property of a Form object. So Me.Controls is a legitimate use of the dot operator to access a property. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, March 03, 2006 11:07 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Table naming conventions For Each ctl in Me.Controls ... Charlotte -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Thursday, March 02, 2006 8:21 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Table naming conventions >But you also use the dot operator to refer to members of a collection, >and the controls are members of the parent object's controls collection. I'm not following you on this one. Can you give an example? John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, March 02, 2006 8:30 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Table naming conventions But you also use the dot operator to refer to members of a collection, and the controls are members of the parent object's controls collection. ;o> Charlotte Foust -----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:47 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Table naming conventions >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 -- 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