Show query results on google maps

[hullstorage]

hi all
we have a query that produces a lot of delivery address all over the uk
and we are trying to map these on google maps from the postcode in the query
any ideas

i have seen a lot of websites using the method to show where there other office and members are etc..

regards

simon

 

[ianward]

I do something similar where I have a combo box with SiteCode, SiteName & Postcode and use a button with the following on the on_click event

    If (Not IsNull(ReferringTrust)) Then
        strSearch = Replace(Me.ReferringTrust.Column(2), " ", "+")
        Application.FollowHyperlink "http://maps.google.co.uk/maps?f=q&hl=en&geocode=&q=" & strSearch & "&ie=UTF8&z=16&iwloc=addr"
    Else
        MsgBox ("You have not selected a Hospital to view")
    End If

The code looks at the postcode and replaces any spaces with '+' so it will work in the link.

hope this helps

Ian

 

[hullstorage]

thanks
think i had this one before, the problem is i have multiple postcodes
so there may be 100+ postcode to show on the map

thanks

 

[ianward]

Sorry - thats the only way i know how, I would imagine you would have to sign up to the google maps API to be able to customise to that degree.

Regards - Ian