I have an Access 2010 database that stores street addresses. Whilst in access looking at a specific record I would like to be able to add a button that says "View on Map". I have the code to open Arcmap but it only opens to the main program and not the specific map I want. Is there a method of opening a specific map? The code I am using so far is :
Private Sub View_on_Map_Click()
Dim stAppName As String
stAppName = "C:\Program Files (x86)\ArcGIS\Desktop10.1\bin\ArcMap.exe"
Call Shell(stAppName, 1)
If it is possible to open to the correct map I would then like to be able to zoom to the specific location associated with the Access database. I would really appreciate some examples of code to do this.