[AccessD] The 10 commandments Access style question?

Not looking for debate. Just trying to be a better
programmer.

And right now it is not feeling like it is working.

Joe Hecht
jmhecht at earthlink.net
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
DWUTKA at marlow.com
Sent: Tuesday, February 21, 2006 7:47 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] The 10 commandments Access style
question?

We've had this little debate before.  Are we trying to liven
this week up a
bit or something?

Drew

-----Original Message-----
From: Gustav Brock [mailto:Gustav at cactus.dk]
Sent: Tuesday, February 21, 2006 4:17 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] The 10 commandments Access style
question?


Hi Shamil and Joe

I still don't like them in tables. In queries, however, they
can be quite
useful, leaving the table design clean. 

I've used them in a set of queries for simple administrative
purposes
(configuration of an app) where an ID is exactly meaningless
while "the
meaning" is mandatory to perform the task. It saved my for
creating a bunch
of forms.

However, I would never use them in an application at the
user level.

/gustav

>>> shamil at users.mns.ru 21-02-2006 10:39 >>>
Joe,

I'd disagree with them and I'd use lookups as much as
possible - lookups are

true development speed up feature and are very useful for
users IMO.

I did read carefully the article they refer to 
http://www.mvps.org/access/lookupfields.htm 

Honestly I didn't like to use lookup fields when they
appeared in Access 97 
and I even recommended to not use them to some people  - I
changed my mind 
for quite some time now - good evolution IMO :)

HTH,
Shamil


-- 
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