Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sun Feb 22 16:51:02 CST 2009
Both dbs were good but I really like the multiple languages in the tag property. That's really...lateral! 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 Max Wanadoo Sent: Sunday, February 22, 2009 2:25 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Find First in an Array? - The Solution Rocky, My last direct posting to you via the mdb addresses all the concerns in your last three posting which have just hit my in-box. It does use the caption.tag to store the language strings but when I get some time I will see about appending a user.property to the form. I think that is doable so you don't need to have to use the .tag. But anyway, the last version allows for instant swapping between languages in a flash. No need to create different versions for different language clients. One version now fits all. It also has code to create all the language strings from the language table - you don't have to type any thing in - just run the code. I would also recommend the options from John, Stuart etc which all have advantages. Have a look. Sorry about the diminishing market but in the UK I think it is starting to pick up again so hopefully that will happen in the US. Take care. 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: 22 February 2009 22:08 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Find First in an Array? - The Solution I'm flexible. I'm bending over for these people right now. 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 Max Wanadoo Sent: Sunday, February 22, 2009 2:30 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Find First in an Array? - The Solution Further to my last posting, Rocky. I suppose you could also give the evaluators the one you currently have where the form get updated each time based on the language selected and tell the potential clients that a language specific option is available with improved form rendering. Then when the order (as they will surely do) give them the translated mde copy, Flexibility is the keyword here, I think. 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: 22 February 2009 08:47 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Find First in an Array? - The Solution Another complication - evaluators can be requested from the web site. I suppose I could ask for the language as part of the request. I'd have to allow them to ask for multiple copies - different languages in case French speaking management wanted to evaluate it as well as the Chinese workers in the factory. IOW, the customer may not know for sure which language they want. Plus I'd have to maintain currently 5 versions of the program - one for each language. 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 Max Wanadoo Sent: Saturday, February 21, 2009 5:12 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Find First in an Array? - The Solution Hi Gustav, Pub is now dry.. came home...ha! Well, if you are sending an MDE you would run the Translation Program then convert to an .MDE and then send it to client and then go back to pub - eh? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: 21 February 2009 23:14 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Find First in an Array? - The Solution Hi Max and Rocky OK, that minor reason turned into a major; you will perform design changes of the forms which isn't possible in an mde. /gustav >>> Gustav at cactus.dk 21-02-2009 16:10 >>> Hi Max Very good! You have point here. It's a bit like Drew's suggestion but with a clever twist which I will leave for others to figure out (I have seen the sample db from Max). I can, however, think of one minor reason to not use your approach. Who said you don't get bright ideas while sleeping? /gustav >>> max.wanadoo at gmail.com 21-02-2009 13:47 >>> Hello Rocky, Well, I have read with interest all the to-ing and fro-ing from the various contributors. So, I laid me down laterally and started thinking laterally. The solution came to be sometime around my 3rd drink. I consolidated my thoughts in bed. When I woke this morning, I tested them out with a sample mdb using English, French and German. All work beautifully. Add as many languages as you want. The solution I have has the following benefits: Instantaneous No variables No Collections No Classes (although the solution could be said to be upper class <ha!> No Arrays No Memory overheads Forms shown the language required every time with no overheads. Unlimited Languages Should I post the sample mdb to you? Max Ps. Bet your intrigued - you will love this solution. -- 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 -- 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 -- 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