Solved

MS Access chinese language issue

Posted on 2012-03-21
2
384 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

688 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