A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Update query with greek characters



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2007, 11:23 PM posted to microsoft.public.access.queries
greeknl via AccessMonster.com
external usenet poster
 
Posts: 27
Default Update query with greek characters

I want to do an update query on a table I imported to change all records to
propercase. So far no problems.
In my table I have also a lot of greek names (in the greek alphabet) and when
I run the query all greek letters are replaced by questionmarks.
As this is a long table I want to avoid doing it all by hand.
Can someone help me?

Thanks

--
Message posted via http://www.accessmonster.com

  #2  
Old April 29th, 2007, 04:41 AM posted to microsoft.public.access.queries
Allen Browne
external usenet poster
 
Posts: 11,706
Default Update query with greek characters

Try creating a form bound to this table.
In Form Design view, select the field that should contain the Greek
characters, and set the Font to a Greek font.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"greeknl via AccessMonster.com" u30909@uwe wrote in message
news:7165e1da696c5@uwe...
I want to do an update query on a table I imported to change all records to
propercase. So far no problems.
In my table I have also a lot of greek names (in the greek alphabet) and
when
I run the query all greek letters are replaced by questionmarks.
As this is a long table I want to avoid doing it all by hand.
Can someone help me?


  #3  
Old April 29th, 2007, 01:37 PM posted to microsoft.public.access.queries
greeknl via AccessMonster.com
external usenet poster
 
Posts: 27
Default Update query with greek characters

I am not quite sure what you mean.
But how would I then convert the complete table to propercase?


Allen Browne wrote:
Try creating a form bound to this table.
In Form Design view, select the field that should contain the Greek
characters, and set the Font to a Greek font.

I want to do an update query on a table I imported to change all records to
propercase. So far no problems.

[quoted text clipped - 3 lines]
As this is a long table I want to avoid doing it all by hand.
Can someone help me?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200704/1

  #4  
Old April 29th, 2007, 04:25 PM posted to microsoft.public.access.queries
Allen Browne
external usenet poster
 
Posts: 11,706
Default Update query with greek characters

I don't understand that reply.

I am not aware of any connection between choosing the correct font so the
text is displayed as characters of the Greek alphabet
instead of question marks, and converting the case of the text.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"greeknl via AccessMonster.com" u30909@uwe wrote in message
news:716d55928e87a@uwe...
I am not quite sure what you mean.
But how would I then convert the complete table to propercase?


Allen Browne wrote:
Try creating a form bound to this table.
In Form Design view, select the field that should contain the Greek
characters, and set the Font to a Greek font.

I want to do an update query on a table I imported to change all records
to
propercase. So far no problems.

[quoted text clipped - 3 lines]
As this is a long table I want to avoid doing it all by hand.
Can someone help me?


  #5  
Old April 30th, 2007, 08:14 AM posted to microsoft.public.access.queries
greeknl via AccessMonster.com
external usenet poster
 
Posts: 27
Default Update query with greek characters

Sorry if I was vague
But when I convert the table to ProperCase, the fileds containing greek words
are converted to questionmarks.
My database works fine with the greek characters, except when performing the
mentioned task.
A real pain...
Thanks anyway for all the prompt replies


Allen Browne wrote:
I don't understand that reply.

I am not aware of any connection between choosing the correct font so the
text is displayed as characters of the Greek alphabet
instead of question marks, and converting the case of the text.

I am not quite sure what you mean.
But how would I then convert the complete table to propercase?

[quoted text clipped - 9 lines]
As this is a long table I want to avoid doing it all by hand.
Can someone help me?


--
Message posted via http://www.accessmonster.com

  #6  
Old April 30th, 2007, 08:47 AM posted to microsoft.public.access.queries
Allen Browne
external usenet poster
 
Posts: 11,706
Default Update query with greek characters

Ah, I think I see.

Using StrConv() with the vbProperCase argument on a field with Greek
characters did not convert a lower case alpha into an upper case alpha as
you expected. Instead it converted to an unreadable/undisplayable character.

That could certainly be the case if the Unicode font used a non-ASCII
character to display the foreign character. Clearly using StrConv() is not
appropriate for this case.

Perhaps someone who works with other fonts and languages could suggest an
alternative approach.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"greeknl via AccessMonster.com" u30909@uwe wrote in message
news:717715e09e9a0@uwe...
Sorry if I was vague
But when I convert the table to ProperCase, the fileds containing greek
words
are converted to questionmarks.
My database works fine with the greek characters, except when performing
the
mentioned task.
A real pain...
Thanks anyway for all the prompt replies


Allen Browne wrote:
I don't understand that reply.

I am not aware of any connection between choosing the correct font so the
text is displayed as characters of the Greek alphabet
instead of question marks, and converting the case of the text.

I am not quite sure what you mean.
But how would I then convert the complete table to propercase?

[quoted text clipped - 9 lines]
As this is a long table I want to avoid doing it all by hand.
Can someone help me?


  #7  
Old April 30th, 2007, 09:42 AM posted to microsoft.public.access.queries
greeknl via AccessMonster.com
external usenet poster
 
Posts: 27
Default Update query with greek characters

Thank you for this answer.
Should I make a new thread using the info you gave me in order to get an
answer or will this post be seen?

Allen Browne wrote:
Ah, I think I see.

Using StrConv() with the vbProperCase argument on a field with Greek
characters did not convert a lower case alpha into an upper case alpha as
you expected. Instead it converted to an unreadable/undisplayable character.

That could certainly be the case if the Unicode font used a non-ASCII
character to display the foreign character. Clearly using StrConv() is not
appropriate for this case.

Perhaps someone who works with other fonts and languages could suggest an
alternative approach.

Sorry if I was vague
But when I convert the table to ProperCase, the fileds containing greek

[quoted text clipped - 17 lines]
As this is a long table I want to avoid doing it all by hand.
Can someone help me?


--
Message posted via http://www.accessmonster.com

  #8  
Old April 30th, 2007, 11:59 AM posted to microsoft.public.access.queries
Allen Browne
external usenet poster
 
Posts: 11,706
Default Update query with greek characters

Give it a few hours. Start a new thread of you don't get any takers.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"greeknl via AccessMonster.com" u30909@uwe wrote in message
news:7177daeba20bc@uwe...
Thank you for this answer.
Should I make a new thread using the info you gave me in order to get an
answer or will this post be seen?

Allen Browne wrote:
Ah, I think I see.

Using StrConv() with the vbProperCase argument on a field with Greek
characters did not convert a lower case alpha into an upper case alpha as
you expected. Instead it converted to an unreadable/undisplayable
character.

That could certainly be the case if the Unicode font used a non-ASCII
character to display the foreign character. Clearly using StrConv() is not
appropriate for this case.

Perhaps someone who works with other fonts and languages could suggest an
alternative approach.

Sorry if I was vague
But when I convert the table to ProperCase, the fileds containing greek

[quoted text clipped - 17 lines]
As this is a long table I want to avoid doing it all by hand.
Can someone help me?


  #9  
Old May 7th, 2007, 07:13 PM posted to microsoft.public.access.queries
greeknl via AccessMonster.com
external usenet poster
 
Posts: 27
Default Update query with greek characters

I came accross the function Ucase() which changes strings to Uppercase.
I hope this will work also in the query because in VBA it worked fine.

Again thanks for all the help

Allen Browne wrote:
Give it a few hours. Start a new thread of you don't get any takers.

Thank you for this answer.
Should I make a new thread using the info you gave me in order to get an

[quoted text clipped - 19 lines]
As this is a long table I want to avoid doing it all by hand.
Can someone help me?


--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.