Connecting Tech Pros Worldwide Help | Site Map

Unicode hieroglyphs support in Access

Newbie
 
Join Date: Aug 2007
Posts: 3
#1: Aug 24 '07
I have mdb file and I designed form on vba within this form one of the fields is has a codes these codes is belonging to a program generating these codes to a hieroglyph signs and I want this filed in vba to edit these codes like this program but I don't now how to do it.

Example:
the code (+s |(5)-N42:t-B1- p-w- n:=t- sw-t:n- n:xt-t:D40- +s-!=120%)


When I write it in the programe it will be like this

http://www.thescripts.com/forum/atta...ntid=480&stc=1

Can we do something to make the filed edit it like this
Attached Thumbnails
presentation1.jpg  
Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#2: Aug 25 '07

re: Unicode hieroglyphs support in Access


Have a look at this site: http://www.freevbcode.com/ShowCode.asp?ID=3278

As well as this one: http://www.unicode.org/charts/

I'm not sure if hieroglyphs are supported yet by unicode, but if you research those two sites, they might point you in the right direction.

As far as displaying them, look up the ChrW() function in vba help. Note: you will need to prefix the unicode character with the & symbol in order for it to display correctly (i.e. ChrW(&H215B))

For your future posts, please do not post in all capital letters. As indicated in the Posting Guidelines, this is considered rude. This part of the Posting Guidelines FAQ covers those issues

Regards,
Scott
Newbie
 
Join Date: Aug 2007
Posts: 3
#3: Aug 25 '07

re: Unicode hieroglyphs support in Access


thanks a lot for your help , and I'm sorry about the upper case, i forget that
best wishes
Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#4: Aug 25 '07

re: Unicode hieroglyphs support in Access


Quote:

Originally Posted by mahmoudsamy

thanks a lot for your help , and I'm sorry about the upper case, i forget that
best wishes

No problem at all! Have a good day, and welcome to the Scripts.

Regards,
Scott
Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#5: Aug 25 '07

re: Unicode hieroglyphs support in Access


In a PM from the OP: (added for informational purposes for anyone who comes across this post in future.)

Quote:

Originally Posted by mahmoudsamy

Dear: Scott
thank u for ur help i really grateful for that, i didn't understand any thing of that because I'm egyptologist i can't do that but the good news i have a programe generate hiroglyphs, it's in .jar format can we use it in access
best wishes
samy

You are quite welcome! It's good to know about the hieroglyphs, I wasn't sure if they were supported yet (or ever will be) in the Unicode standard. If they become available in unicode, they will be available to access (and all other unicode enabled programs) also.

Regards,
Scott
Newbie
 
Join Date: Aug 2007
Posts: 3
#6: Aug 25 '07

re: Unicode hieroglyphs support in Access


then what can i do Scott
Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#7: Aug 25 '07

re: Unicode hieroglyphs support in Access


Quote:

Originally Posted by mahmoudsamy

then what can i do Scott

.jar format is something that I'm not familiar with. However, it is likely to be some kind of image format? In that case, you can use the embedding feature of Access to embed the image in your field.

There are several commercial products available that do this (at least claim to do so... I've not used them myself) without some of the common problems that can be experienced embedding images in a database: Have a look at this thread that contains links to information about embedding images, as well as a couple of commercial products that help in the process: http://www.thescripts.com/forum/thread690885-dbpix.html

Regards,
Scott
Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#8: Aug 25 '07

re: Unicode hieroglyphs support in Access


Just going back and re-reading your original post, there are a couple of things not clear to me.

Are you wanting to edit the images themselves using VBA in Access? or simply display them in a different order?

If what you are wanting to do is actually edit the images themselves, this is theoretically possible, but Access is the wrong tool to do this with.

My previous answers have been assuming you want to do the second.

Regards,
Scott
Scott Price's Avatar
Moderator
 
Join Date: Jul 2007
Location: Seattle, WA
Posts: 1,314
#9: Aug 25 '07

re: Unicode hieroglyphs support in Access


Please also have a look at this website: http://www.egpz.com/resources/pdf/EGPZ-BMP-0.1.pdf

And this one: http://www.gameset.com/resources/unicode/egpz.html

Regards,
Scott
Reply