Automatically translation

G

gstylianou

Registered User.
Local time
Today, 23:26
Joined
Dec 16, 2013
Messages
359
Good afternoon,

I am sure that my new post its so interested for many members so I think that if we found solution for that everybody will be happy.

Is there a way for automatically translate (as far as possible) a name from Greek to English or vice versa?

Example:
George Stylianou is Γιώργος Στυλιανού

I attach the base and everything I will come back to
 

Attachments

Hi. How do you define "automatically" in this case? As the user types or enter something, or by clicking a button?
 
theDBguy said:
Hi. How do you define "automatically" in this case? As the user types or enter something, or by clicking a button?
Click to expand...

Hi The_DOCguy,

The ideal is On After Update but anyway the problem is to find a way to do that... Is that a way?
 
gstylianou said:
Hi The_DOCguy,

The ideal is On After Update but anyway the problem is to find a way to do that... Is that a way?
Click to expand...
Hi. I haven't looked at your attachment but it might be possible using a web service like Google or Bing translate.
 
theDBguy is probably right to point you to an external service.

The problem is that Access is a subject-matter expert in one and ONLY one thing - the tables, queries, forms, reports, macros, modules, and relationships of an Access application. It knows NOTHING about other languages at the level of translation. The English or French or German or Greek or whatever other language versions were translated by Microsoft and you select one of them from the installation kit. But there is no dynamic translation.

You could try to "roll your own" translator, but you have two issues to consider.

First, ANY translation would have to be done externally to Access OR you would have to write the translator yourself.

Second, you specifically asked about name translations, but at least in the USA we have many variations of a name. So "George" could be "Georg" and I have even seen "Jarg" (probably a variant on "Jorge", the Hispanic form of the name). If such a thing happens in Greek names, then names will not translate well anyway. You would do better to have the Greek version of each user's name in a table and just display that where appropriate.
 
It's been a few years since this exchange, but you may find this post and database by ADezii useful. Any comments welcome.

Good luck.

HHMmmmmm??? Just tried the routine with NO success. I know it did work when posted originally???


A little investigation:

Looks like you need a Google account/registration??? code of some sort.
Code: 
<!DOCTYPE html>
<html lang=en>
  <meta charset=utf-8>
  <meta name=viewport content="initial-scale=1, minimum-scale=1, width=device-width">
  <title>Error 403 (Forbidden)!!1</title>
  <style>
    *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_col
or_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}
  </style>
  <a href=//www.google.com/><span id=logo aria-label=Google></span></a>
  <p><b>403.</b> <ins>That’s an error.</ins>
  <p>[B][COLOR="Red"]Your client does not have permission to get URL [/COLOR][/B]<code>/translate_a/t?client=t&text=cat%20and%20dog&hl=en&sl=en&tl=fr&multires=1&pc=0&rom=1&sc=1</code> from this server.  <ins>That’s all we know.</ins>
 
Last edited:
You must log in or register to reply here.

Similar threads

B
Database structure
Replies
19
Views
768
LarryE
LarryE
V
Code that worked suddenly started throwing errors?
Replies
10
Views
468
Pat Hartman
P
asteropi
Not sure what error this is
2 3
Replies
40
Views
1,433
gemma-the-husky
gemma-the-husky
109bow
formatting a cluster column chart
Replies
5
Views
194
isladogs
isladogs
A
Having trouble with a combo box
Replies
17
Views
649
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom