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