Solved

MS Access chinese language issue

Posted on 2012-03-21
2
368 Views
Last Modified: 2012-04-17
I have  a control label lookup function below that returns the translation by LanguageID.



The chinese characters seem to not work with the controls.  I get (??) when I paste them into the VBA editor.

I tried chaning the font type but still not luck.

Any thoughts on how to accomplish this?  

I don't want to hit the DB to get the control label if possible.

Thanks





Public Function Load_Title(lang As Integer, langType As String) As String
    Dim x As Integer
    Dim s As Variant
    x = ModGlobalID.CurrentLanguage
   
'   language: english, spanish, chinese, hungarian
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    Select Case langType
   
    Case "application"
     If lang = 1 Then s = "Monthly,Mensual,Havi,??"
     If lang = 2 Then s = "CR Matrix,CR Matrix,CR Matrix,Cr?"
    Case "common"
         If lang = 1 Then s = "No Entity Selected,No Entidad Seleccionada,Nem Entity Kiválasztott,??????"
         If lang = 2 Then s = "Date,Fecha,Dátum,??"
         If lang = 3 Then s = "Search,Buscar,Keresés,??"
         If lang = 4 Then s = "Remove,Quitar,Eltávolítás,??"
         If lang = 5 Then s = "Name:,Nomenclatura,Név:,???"
         If lang = 6 Then s = "Phone:,Teléfono:,Telefon,??"
         If lang = 7 Then s = "Fax:,Fax:,Fax,???"
         If lang = 8 Then s = "Email:,Email:,E-mail:,?????"
         If lang = 9 Then s = "InnoPage:,InnoPage:,InnoPage:,InnoPage?"
         If lang = 10 Then s = "Filter,Filtro,Szuro,???"
         If lang = 11 Then s = "Remove,Quitar,Eltávolítás,??"
 End select

    s = Split(s, ",")
    Load_Title = s(x - 1)
End Function
0
Comment
Question by:skillilea
2 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 37751390
Have you installed the Chinese language display in Windows? - Control Panel> Regional Settings somewhere.


Kelvin
0
 
LVL 22

Accepted Solution

by:
danaseaman earned 500 total points
ID: 37752315
Go to Control Panel and change your default language to Chinese
Restart your machine and you should be able to type (via IME) Chinese in the VBA Editor.

Other options are to store Unicode strings in Access MDB, a Unicode Text File, Unicode INI File, or XML File.

In Vb6 it is easier, you can use a Resource File that has Unicode strings and read them easily with GetResString.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question