Solved

A Unicode VBA IDE?

Posted on 2013-01-18
4
1,453 Views
Last Modified: 2013-01-19
Hello experts! I've created an Access application on the idea of flashcards for learning new languages.
After you get into the application you choose which language you want to study. Then you  can watch a series of "cards" I had prepared, with words in the foreign language, and play some games with them etc. You can also insert new foreign words if you want.
My language is Hebrew, so my codepage in windows is Hebrew. This enables me to write some Hebrew in VBA code, for displaying MsgBox with Hebrew messages and so on.
The problem is: once my codepage was set to Hebrew, I can't write anything in the foreign language into VBA code - things like "u" with 2 dots over it for German or Turkish, c with a cedilla underneath for Portuguese, the special yumushak-G for Turkish, or any other foreign characters not present in the basic char-map of English/Hebrew. If I set windows codepage to Turkish, I would be able to write Turkish characters in VBA code, but not any other foreign characters of other languages, and so on.
Is there a way to overcome the non-Unicode-nature of VBA environment? Thank you.
0
Comment
Question by:NNOAM1
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:als315
ID: 38794178
You can write unicode text to tables and show message according selected language
DBmultilang.accdb
0
 

Author Comment

by:NNOAM1
ID: 38794269
Ok. I managed to work around this problem using data stored in tables. Still, Aren't there any VBA functions to convert character-codes into some other codes and this way to write some Unicode text directly in VBA?
0
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 38795927
You can't mix codepages in VBA editor. It doesn't support unicode.
You can only add unicode to text strings with chr function. For example, open word, find nesessary symbol:
symbolyou can add this symbol to any text string with ChrW function: str = str & ChrW("&H016C")
Here you can find other approach to this problem:
http://www.utteraccess.com/forum/index.php?s=&showtopic=1721616&view=findpost&p=1722020
0
 

Author Closing Comment

by:NNOAM1
ID: 38796001
Thank you!
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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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 …

785 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