Solved

A Unicode VBA IDE?

Posted on 2013-01-18
4
1,476 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 40

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 40

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

856 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