Google Translator with Microsoft Access VBA

Has anybody successfully got Google Translator working with Access.

For now I just want to have a form with 3 fields
  • The language to translate from
  • The text in the chosen language
  • The translated text in English
Then a "Translate" button which executes the code.
rick_dangerAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
Like Google Maps, you can create your own "on demand" translate form and display the results in Google Translate
Code roughly like this:
    Application.FollowHyperlink "https://translate.google.com/#" & Me.cboOriginalLanguage & "/" & Me.cboTranslateTo & "/" & Me.txtText

Open in new window


So, something like this:
formDisplays this:
webpage
sample db is attached

JeffCoachman
Access-Google-Maps-and-Google-Tran.accdb
0
 
Máté FarkasDatabase Developer and AdministratorCommented:
This is not so simple. You need to use online Google Translate API.
But if it is enough for you to open a browser window with translated text then it is simply:
You need to call: https://translate.google.com/#<from_lang_iso2_code>/<to_lang_iso2_code>/<test_to_transalte>
0
 
rick_dangerAuthor Commented:
Thanks for your answer. I was looking for something that used the API that is apparently available.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Shaun VermaakTechnical Specialist/DeveloperCommented:
An easy solution would be to create a web-service that response to get response containing a query-string text that needs to be translated and respond with the translated text. Then you can just use web request in VBA
0
 
rick_dangerAuthor Commented:
Thanks for getting back to me.

I suppose that's the bit where I'm stuck - using the web request, whether it be using Google Translate or something else.
0
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
I think it will be complicated without writing your own "middle-ware" web-service.
0
 
rick_dangerAuthor Commented:
Jeff - thanks for your reply. That's very useful - I suppose I'm being greedy, but is there any way of getting it to then put the translation back into the Access form?

Not being lazy, just got no idea how to do it!
0
 
Jeffrey CoachmanMIS LiasonCommented:
is there any way of getting it to then put the translation back into the Access form
Probably not without the API...

Note that the API may not be compatible with Access VBA though...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.