Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old August 18th, 2013, 06:33 PM
drb555 drb555 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2013
Posts: 2 drb555 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 m 13 sec
Reputation Power: 0
Problems with turkish charachters in VBA coding

I have some reports which need to be created in either english or turkish.
the data displayed is not the problem.
I change the field labels to read in turkish or english depending on which language is required.
however some turkish characters
specifically
Ğ ğ ı İ Ş ş
will not display in the vba editor and I have to resort to using
ChrW(286)
ChrW(287)
ChrW(305)
ChrW(304)
ChrW(350)
ChrW(351)
in the code to change the labels

obviously this can be quite time consuming especially when I have large chunks of text to check and convert.

I was thinking that I could create a form where I could type in the text and it would be read and checked for those characters and they could be replaced with the correct codes and then I could paste that directly into the VBA code.
something along these lines
KİRA SÍZLEŞMESİ
which would return
"K" & ChrW(304) & "RA SÍZLE" & ChrW(350) & "MES" & ChrW(304)

I have a table with the special codes in, and I imagine that I need to do some form of lookup there, but it is the reading the original text and checking for characters that I have problems doing.

Any help would be greatly appreciated, otherwise I have endless hours of manually going through text and the inherent problems that will cause.

I should reiterate in Access forms/reports etc the characters display ok, it is only in VBA there is a problem.

Reply With Quote
  #2  
Old August 19th, 2013, 04:39 PM
drb555 drb555 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2013
Posts: 2 drb555 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 m 13 sec
Reputation Power: 0
Quote:
Originally Posted by Dian3men
obviously this can be quite time consuming especially when I have large chunks of text to check and convert.
am I missing something?

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Problems with turkish charachters in VBA coding


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap