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

Ok, I think Max emailed out his database, I didn't see any specific
code.  But the concept was initially to put all the translations into
the captions .Tag property, in a 'master' copy, and then create a
language specific database.

It's a great idea (good job Max!).  But there are draw backs:

1.  Your languages are in the Tag property. (Think that's not a
drawback?  Ask someone to proof the translations, or add new
translations..... you either go through each and every control, find
something to run through them all, etc.  having the translations in the
table makes it easier for changes, additions, and proofing).

2.  2048 character limit.  Sure, for your command buttons and labels on
your forms, no big deal.  If you have a more paragraph style 'label' on
a report (or even a form for that matter, but I would assume they would
be more common on a report), you're going to hit that limit.

3.  No 'event' driven changes.  With the example I posted, the
'changing' form (Form1) could easily be setup as a Menu bar.  Allowing
anyone sitting at a console to switch to whatever language they want.
And instead of having to find all the open forms/reports, the raised
event would change everything automatically. (Without having to open and
close the forms)

But again, it is a great idea.  (Kudos Max!)

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

So let me get this clear. Your argument is:

1.  I need to store a string value for each control. 

2.  Controls has been designed with a property specifically for this
purpose. 

3.  I won't use the property in case I need to use it for something else
later on,  instead I will 
build a complete new system which will allow me to do all sorts of neat
things with controls 
in case I need to in the future.  

May I refer you to Shamil's posting last Friday in this thread?

<quote>
May I warn you about what is known as:
"Premature Optimization"
http://c2.com/cgi/wiki?PrematureOptimization 
and 
"Premature Generalization" 
http://c2.com/cgi/wiki?PrematureGeneralizationIsEvil 
Have a look:
"Death by premature generalization" 
http://ryanfarley.com/blog/archive/2004/04/30/570.aspx
</quote>

-- 
Stuart

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.