Access the internet using MSAcces

[FF Diz]

I would like to use google maps to look up an address in my database. I will
need step by step if I have to use VBA commands. Thanks

 

[Daniel Pineault]

Look into the FollowHyperlink Method

Application.FollowHyperlink "http:\\www.google.ca"

You can pass any valid url to it including Google Maps.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Wayne-I-M]

Hi FF

Just to add to what Daniel said correctly - you need to use the follow
hyperlink.

But you need to add some "stuff" to it to get it to ork with google maps.
Also - you need to alter the zip/post code to make google maps understand it.

Most importantly you can NOT send the link (url) direct to google and hope
it will work on the right map - it won't. So you also need to tell google
maps "which" bit of the world you want to see as you map.

Have a look at this answer I gave a while ago.

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/7ca07b770f7cc16b

This will give you a step by step. If you have problems post answer
question and someone here will be able to answer

Good luck with your application

 

[FF Diz]

MyHyperlink =
"http://maps.google.com/maps?g=q&hl=en&geocode=&time=&date=&ttype=&q=" &
strGoogleLoaction

Worked the way I wanted it to.

I have another dilema:
I want to look up owners of properties using MD property search. the link I
am trying to automatically enter the address is below. Can you help?

http://sdatcert3.resiusa.org/rp_rewrite/searchtype.aspx?County=03&SearchType=street