Unanswered: Language Translation & Keyboard Characters
My client desires that certain text in the data tables of the application I am building be available to users in Spanish and Russian both in forms and reports.
I feel confident about the ability to create additional tables with translated text but am unsure how to handle special keyboard characters, particularly in Russian for display on the PC prior to printing. Any thoughts on this subject and references to possible resources would be greatly appreciated.
In addition, in 2 cases within the running of the program, she wants a translation from English to one or the other language on the fly. I have spent considerable time looking for possible translators with little success. Again, I'd sure appreciate comments from those who have built similar environments.
I have not gained much information since posting. In searching the Newsgroups I ran across a convention for incorporating all languages into a character code called Unicode. Apparently this is an expanded character set from ASCI that is 2 bytes in length and can incorporate any language used today, the larger size being able to hold a much larger range of characters.
According to what I have read, this was a major enhancement from Access97 to 2000. Yet, I found little about using Unicode in VBA coding. There are font sets for Unicode, perhaps rather limited. I found references to two, Code2000 and Arial Unicode MS. Are there more and where are they to be found?
If these font sets are not commonly found, can I incorporate them in a commercially produced program?
What bothers me is that I found nothing on how to leverage Unicode. For example, it I created two related data tables, one in English and another in French then wanted to display or print both out of a query would this require any thing out of the ordinary? This I will experiment with today.
Microsoft has included language support to Windows 2000 O/S and later for Unicode and a variety of keyboard languages in Win98 and later. I have found that the selection of languages varies from one O/S to another. For example I found Russian on my Win98 PC but not on Windows 2000.
I have spent considerable time searching in forums and newsgroups for information about this capability but without success. I do not even know Microsoft's standard name for this capability. I found the following possible keywords that might reference it but not one explicit document describing it. The keywords are multilingual pack, codepage and Start/Programs/MS Office Tools area.
I do not understand how MS can support several foreign languages in Win98 if this O/S does not support Unicode either.
I need to obtain information if it is possible to incorporate specific languages in a deployable run-time Access XP CD specific languages and the capability to install them on the PC of a person purchasing the program if any of these languages are missing from the PC's selection list.
I would appreciate hearing from anyone with knowledge in these subjects, if such deployment is possible and advice on how I might do this.