[AccessD] Code Help Please

LOL, no, it wasn't JWC, but I think my friend worked with him on a
project one time.

You should see some of the queries I had in code for his systems. One
that comes to mind was a project where he wanted a button that opened
IE, went to a Texas website for workers comp, then filled in the fields
on the website with the data from a query.  The query SQL in the code
page was as long as the code to do the actual work was, and then some!

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Thursday, March 06, 2008 5:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Code Help Please

Hmmn .... I wonder who that could be?  As I recall, JC likes to create
field names that identify their tables, etc.  Could it be .... NAW!! Of
course not.  

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Thursday, March 06, 2008 3:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Code Help Please

I didn't feel the earth shake!?!  That usually only happens when JWC and
I agree! ;)

I do some side work with a fellow that had a real bad habit of creating
complex field names.

For instance, if he had an Incident Number in tblIncidents, he'd name it
I_txt_pk_Incident_Number.  And if that field was in another table, such
as tblInsuranceResult, it would be I_txt_fk_Incident_Number.  'I'
represents that it's in the incident table, txt for text data, pk or fk
for primary key, foreign key, and then the actual field name.  Seems
very practical until you get to the level where you write the SQL by
hand....and then it is just a complete pain in the neck! ;)

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Thursday, March 06, 2008 4:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Code Help Please

Field names are the one place where I most emphatically do NOT use
naming conventions.  It has always seem unnecessary to me, since it does
nothing for your code, the place that naming conventions come into their
own.

Charlotte Foust

The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.