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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:<from_lang_iso2_code>/<to_lang_iso2_code>/<test_to_transalte>
Rick DangerAuthor Commented:
Thanks for your answer. I was looking for something that used the API that is apparently available.
Shaun VermaakTechnical SpecialistCommented:
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
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

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.
Shaun VermaakTechnical SpecialistCommented:
I think it will be complicated without writing your own "middle-ware" web-service.
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 "" & Me.cboOriginalLanguage & "/" & Me.cboTranslateTo & "/" & Me.txtText

Open in new window

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


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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!
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...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.