John Skolits
askolits at ot.com
Mon Jan 1 20:29:53 CST 2007
Rocky, "translation service in Word" Actually, I never really knew about that before. I know with Alex's program placed some code on the 'OnOpen' event that goes to a MsAccess table that had the translations. It enumerated through all the controls on a form/report and looked up the translation. Is that how Word does it? I ended up adding a menu that would allow me to switch between different languages on the fly. I would select a language and the app would change over. Never had to shut down the app. Yes, it's a pain, but the fonts and controls lengths have to be modified for the different languages. I think what I did for my apps (this was a while ago) was to add a field to the translation table for the control's width so when the OnOpen event runs the translation software, it would also modify the width of the control accordingly. The other thing I liked about Alex's program was the ability to modify the MsgBox text embedded in the modules. It essentially replaced the MSGBox line of code with a function call to the translation table. I ended storing all the translation code and tables in an MDE that I referenced as a library function. In this way, I could use the same translations for all my apps. Just had to run Alex's routine to add the functions to the OnOpen events of the forms and reports and I was all set. It really was slick. John -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access Software Sent: Saturday, December 30, 2006 10:26 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Spanish Translations I got the demo and saw that actually it was using the translation service in Word. His program just took care of the export/import. I already had everything in tables so I exported the English to a word doc and used this research-->translate function which I never knew was there. There's still going to be a lot of tweaking because the translations are different lengths than the English so the label and button widths need to be adjusted for every new language. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits Sent: Wednesday, December 27, 2006 4:11 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Spanish Translations Well, I was asked by a customer about translating my app to about 5 different languages. I got Alex's program, customized it a bit and had it finished in a day. They were amazed. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: Wednesday, December 27, 2006 4:47 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Spanish Translations I remember the original program was sold from the Moscow Access User Group site. Michael Kaplan gave it his recommendation and he wrote a book on VB6 Internationalization. John Skolits wrote: >Oh well, I actually 'used' them but suing them must have been on my mind at >the time I suggested it. (I guess.) > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson >Sent: Wednesday, December 27, 2006 3:58 PM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] Spanish Translations > >Did you Sue them, or Use them? ;)) > >Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com > >RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland >21231-3305 > >410-537-6098 direct | 410-276-2136 fax | www.rtkl.com > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits >Sent: Wednesday, December 27, 2006 11:24 AM >To: 'Access Developers discussion and problem solving' >Subject: Re: [AccessD] Spanish Translations > >Rocky, > >You may already know about this, but are you using Alex Dybenko language >translator program. I sued it quite a few years ago and it was slick. >You >still have to map translations but you can switch between the languages >on >the fly. I just visited his website and didn't see the program >mentioned. >Maybe he gave up on it, but when I used it, it worked really well. > >His web site is: http://alex.dybenko.com/ > >John Skolits > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >bchacc at san.rr.com >Sent: Wednesday, December 27, 2006 9:08 AM >To: accessd at databaseadvisors.com >Subject: Re: [AccessD] Spanish Translations > >Thanks Jim. That will be really helpful. I'll try not to take >advantage. > >Regards, > >Rocky > > >Original Message: >----------------- >From: Hale, Jim Jim.Hale at fleetpride.com >Date: Tue, 26 Dec 2006 09:18:02 -0600 >To: accessd at databaseadvisors.com >Subject: Re: [AccessD] Spanish Translations > > >Rocky, >My wife's native language is spanish and she has a business background. >She'll be happy to help. Write her at nhale at houston.rr.com > >Regards, >Jim Hale > >-----Original Message----- >From: Beach Access Software [mailto:bchacc at san.rr.com] >Sent: Sunday, December 24, 2006 8:27 AM >To: 'Access Developers discussion and problem solving' >Subject: [AccessD] Spanish Translations > > >Dear List: > > > >I am translating my manufacturing software into Spanish with the help of >my >son and a couple of users of the system in Mexico. Is there anyone on >the >list here who speaks Spanish of whom I could ask a few translations of >technical and manufacturing terms? > > > >MTIA, > > > > > >Rocky Smolin > >Beach Access Software > >858-259-4334 > >www.e-z-mrp.com > > > > > -- Marty Connelly Victoria, B.C. Canada -- 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 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.29/607 - Release Date: 12/28/2006 12:31 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com