Drew Wutka
DWUTKA at Marlow.com
Tue Feb 24 18:11:36 CST 2009
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.