John Colby
jwcolby at ColbyConsulting.com
Thu Mar 2 22:27:18 CST 2006
>I recently had to update a series of A97 applications to XP. I think that the Dot operator referring to controls was supported in A97 but they were already strongly suggesting switching the syntax. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Thursday, March 02, 2006 9:22 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Table naming conventions On 2 Mar 2006 at 18:55, John Colby wrote: > 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. > I recently had to update a series of A97 applications to XP. The original developer had used "Me." in a number of places to refer to controls and I had to change then to "Me!" before the upgraded app would compile. Unfortunately, I can't rememer the exact error that they were throwing when I tried to compile. -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com