[AccessD] Find First in an Array? - The Solution Revisited - Now Tag is the Answer

Drew Wutka DWUTKA at Marlow.com
Tue Feb 24 16:49:12 CST 2009


On top of that, loading the controls into memory, when a form loads,
you're still putting all that stuff into memory....

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, February 24, 2009 3:35 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Find First in an Array? - The Solution Revisited
- Now Tag is the Answer

 >No you don't; code for manipulating tags to store multiple values has
been floating around since 
A2 and has been discussed numerous times on this list.

That is true Jim.  It is however almost exactly analogous to
denormalizing a table by storing a ton 
of entirely unrelated data in a single field in a table.  Sure it can be
done, but you won't catch 
me doing it (anymore).  The pluses just don't outweigh the minuses.  Put
that same stuff in a table 
and load it from there as the form opens.  Once you load it you REALLY
don't need to place it in a 
tag because you have much better constructs to use.

I am sure it used to make sense back when a computer was dog slow, only
had 64 megs of memory, and 
had slow hard disks, slow networks and so forth.  To try and justify it
now becomes a stretch.

John W. Colby
www.ColbyConsulting.com

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.





More information about the AccessD mailing list