Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sun Feb 22 16:07:04 CST 2009
Yes, one master copy but each time I make an update I have to create the foreign language versions and distribute them to the right customer. This is actually how I did it in the DOS version way back in the day. And once again I find myself wishing that I had enough business to make this a real problem. Do you know how many small manufacturers there are right now who are interested in investing in productivity software to increase their profitability in an expanding market? And if you find one please let me know. :( 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 1:50 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Find First in an Array? - The Solution >>Plus I'd have to maintain currently 5 versions of the program - one >>for each language. I think that one English version would be all that is needed UNLESS you have differing design constraints within the differing language versions. IOW, the problem you originally posted was to overcome the flicker/speed problem when opening forms due to the fact that the form's captions had to be converted each time. You also indicated that you send out an mde - I presume the same mde for all clients. Therefore, if I am correct in the above (kick me if I am not Rocky) then you only need the one master copy. Ie, master.mdb gets copied to Chinese.mdb. Chinese.mdb is then opened and the translation routine run. Chinese.mdb is then converted to Chinese.mde. Chinese.mde is then sent to Chinese Client. Chinese client then runs the Chinese Version of your application with all forms correctly captioned in Chinese and no conversion required when forms up. Repeat above for other languages. But you only need the one master which is copied from each time. 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