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

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Tue Feb 24 18:04:20 CST 2009


One of those objections - proofing the translations -  he actually designed
around with some code that updates the tags from the table.  That's because
one of my requirements was to be able to add a new language by adding a
field to the table and then sending the table to the translator.  So when
the table comes back with the translations, run the update and you're done.
So you don't actually ever have to physically mess with the tags.

I don't think I have any control translations that are over 50 characters or
so.  In fact I just looked and the longest concatenation of the 5 languages
is 638 characters.,  so the 2048 character limit is not too much of a
constraint.  I could do at least 15 languages that way.  Heaven forefend.



Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Tuesday, February 24, 2009 3:18 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Find First in an Array? - The Solution Revisited
-NowTag 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.


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