Drew Wutka
DWUTKA at Marlow.com
Tue Feb 24 17:42:21 CST 2009
Well somebody send it to me! Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Tuesday, February 24, 2009 5:38 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Find First in an Array? - The Solution Revisited-NowTag is the Answer ...you REALLY need to look at what max did ...you're way off base. William -------------------------------------------------- From: "Drew Wutka" <DWUTKA at marlow.com> Sent: Tuesday, February 24, 2009 6:17 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com 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.