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

Max Wanadoo max.wanadoo at gmail.com
Wed Feb 25 02:05:42 CST 2009


Yeah, but I post the most controversial coding <G>

Max
Laugh more than cry.  Smile more than frown.  Be generous in  spirit.  And
always stand your round in the pub!



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: 25 February 2009 00:14
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Find First in an Array? - The
SolutionRevisited-NowTag is the Answer

Hey, I may not be the world's most sophisticated Access programmer but I ask
good questions.  Look at the legs on this thread!


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 4:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Find First in an Array? - The
SolutionRevisited-NowTag is the Answer

Yes, I've seen the example.  

Sorry I changed your table structure for my example, it's a habit to want to
spread it out more.  Technically, there should be a language table with the
font used, and instead of the Language name in the controls table, it should
be a key....

Either way... LOL.  

I've got some comments on Max's example though, will post in a new thread.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, February 24, 2009 6:04 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Find First in an Array? - The Solution
Revisited-NowTag is the Answer

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.

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

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