Unicode hieroglyphs support in Access

[mahmoudsamy]

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

[Scott Price]

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

[mahmoudsamy]

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

[Scott Price]

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]

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

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

[mahmoudsamy]

then what can i do Scott

[Scott Price]

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]

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]

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