how to use the google map in ms access

[johnbros]

i am trying to use google map in my access application. I already search on Google but none of my business. Any help would be appreciated. my code is that...

Private Sub GMapsLink_Click()
Dim strLinkUrl As String 
Dim strPath As String 
Dim strAddr() As String 
strPath = " address of google map website";
strLinkUrl = RTrim(streetnumber.Value) & "+" & RTrim(city.Value) &
"+" & RTrim(state.Value)
strAddr = Split(strLinkUrl, " ", , vbTextCompare)

strLinkUrl = ""
strLinkUrl = strPath & Left(strLinkUrl, Len(strLinkUrl) - 1)
Debug.Print strLinkUrl
Me.GoogleMapsLink.HyperlinkAddress = strLinkUrl
End Sub

[Seth Schrock]

I don't know what version of Access the web browser control was added, but I know it is in Access 2010. So if you are using Access 2010 or newer, view the following link: Web Browser Control. I have seen an example of one being used but I can't find it now.