Map Search in Access

[FrankJ]

I have an access database project and I want to be able to locate an address using the google map from my program using a code.


In otherwise upon clicking this button in the access database will automatically open the google map putting the address online.

I need help somebody

 

[stopher]

Hi

The following should get you on your way...

Dim postcode, street, town As String

postcode = "SW1A 1AA"
street = ""
town = ""

myAddress = (street + " ") & (postcode + " ") & town

FollowHyperlink "http://maps.google.co.uk/maps?f=q&hl=en&q=" & myAddress

Obviously you can grab the address details from wherever suits e.g. from a form.
You might also want to change the code so if the postcode is entered then the street/town are ignored.
Postcode is a uk thing but I assume zip codes will work the same.

For all non-Brits, the postcode I gave as an example is the address of our beloved queen

Stopher

 

[boblarson]

Double posting - the answer was also given here:
http://www.access-programmers.co.uk/forums/showthread.php?t=125954