[AccessD] Conversion

The field names in the language tables have the language name embedded 
in them: fldLanguageChineseComplex,  fldLanguageChineseSimple,  
fldLanguageFrench.  When the user selects their language preference from 
the preferences form in the utilities menu, I save the field name in the 
Preferences table. 

They also have the option to check a Unicode box.  Figuring out how to 
handle Unicode was the trickiest part of it for me. 

I have 8 translate routines because the translate thing developed over 
some time solving different little problems.  It could probably be 
reduced to a couple but since it's working well I didn't have the 
motivation to go back and polish it up.  There are some special 
differences for sub-forms and sub-reports.

The basic form or report translate routine gets the form or report name 
passed to it.  The code cycles through all of the control on the form or 
report checking to see if that control name is in the table.  If so, it 
gets the appropriate translation and changes the control - mostly the 
caption property.  The translate routine for the message boxes runs the 
same way, only I pass the name of the message to the translation routine.

Rocky

Susan Harkins wrote:
> How do you tell the forms, controls, etc. which language to use? Are there
> many routines, or just one? 
>
> Susan H. 
>
> Doris:
>
> At form or report load time I call one of several translate routines which
> go to the tables, find the control in questions and replace the caption or
> whatever with the field from the record is specified by the user's language
> preference.  To do Asian languages I had only to load the Eastern Asian
> Language support in Windows and, walla!, up it came in Chinese. (Of course I
> have no earthly idea what it says, I have to trust the translator.)  The
> translate routine did need to accommodate Unicode, because I guess that's
> what Chinese characters are stored in.  I think it's a double word for each
> character.
>
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com