Question How to add a "map" button

[G1ZmO]

Hi

We have a delivery form which includes the customer address as part of a combo box

I'd like to add the facility to click a button next to the address that will open a Google Map or Bing map of the area, perhaps with the street name and/or postcode.

Can anyone point me in the direction of how to achieve this (with minimal scripting)?

Thanks

Paul

 

[Mr. B]

Here is a link that might help:

http://bytes.com/topic/access/answers/841021-follow-hyperlink

 

[Extra_Cover]

Try the following on the on click event of your button.

strSearch = Replace(Me.lcus_postcode, " ", "+")

Application.FollowHyperlink "http://maps.google.co.uk/maps?f=q&hl=en&geocode=&q=" & strSearch & "&ie=UTF8&z=16&iwloc=addr"

replace Me.cus_postcode with Me.your postcode control name

 

[G1ZmO]

Perfect! Thanks

I had to use this as it pulls the postcode from a combo but it works fine now

strSearch = Replace(Me.cboCollectionCustomerID.Column(11), " ", "+")

Thanks again

Paul