[AccessD] Table naming conventions

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




More information about the AccessD mailing list