Solved

A Unicode VBA IDE?

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

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…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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 …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now