topic Zoom to Point in ArcGIS10.1 from command in MS Acces 2007 in Mapping Questions https://community.esri.com/t5/mapping-questions/zoom-to-point-in-arcgis10-1-from-command-in-ms/m-p/614370#M6687 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to open ArcGIS and zoom to a point on my "Supports" layer based on the current form 'frmSprt' in MS Access. Currently I am able to open ArcGIS from Access using the basArcMap module found here:</SPAN><BR /><BR /><A href="http://forums.esri.com/Thread.asp?c=93&amp;f=992&amp;t=172834">http://forums.esri.com/Thread.asp?c=93&amp;f=992&amp;t=172834</A><BR /><BR /><SPAN>But, get an automation error in the basZoom module. I attached the txt file of the basZoom module I am using. The form and ID in Access is frmSprt.SP_ID. The layer and field in ArcGIS is "Supports" and "SP_ID". </SPAN><BR /><BR /><SPAN>When I run the module, I get an automation error on the 'Set pSelSet = pTable.Select(pQFilter, esriSelectionTypeIDSet, esriSelectionOptionNormal, Nothing)' line. </SPAN><BR /><BR /><SPAN>Has anyone tried this connection in ArcGIS10? I am using the VBA Visual Basic Editor. </SPAN><BR /><BR /><SPAN>Any help would be much appreciated!!!!!!!!</SPAN></BODY></HTML> Thu, 26 Jul 2012 13:50:28 GMT KellieLinville 2012-07-26T13:50:28Z Zoom to Point in ArcGIS10.1 from command in MS Acces 2007 https://community.esri.com/t5/mapping-questions/zoom-to-point-in-arcgis10-1-from-command-in-ms/m-p/614370#M6687 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to open ArcGIS and zoom to a point on my "Supports" layer based on the current form 'frmSprt' in MS Access. Currently I am able to open ArcGIS from Access using the basArcMap module found here:</SPAN><BR /><BR /><A href="http://forums.esri.com/Thread.asp?c=93&amp;f=992&amp;t=172834">http://forums.esri.com/Thread.asp?c=93&amp;f=992&amp;t=172834</A><BR /><BR /><SPAN>But, get an automation error in the basZoom module. I attached the txt file of the basZoom module I am using. The form and ID in Access is frmSprt.SP_ID. The layer and field in ArcGIS is "Supports" and "SP_ID". </SPAN><BR /><BR /><SPAN>When I run the module, I get an automation error on the 'Set pSelSet = pTable.Select(pQFilter, esriSelectionTypeIDSet, esriSelectionOptionNormal, Nothing)' line. </SPAN><BR /><BR /><SPAN>Has anyone tried this connection in ArcGIS10? I am using the VBA Visual Basic Editor. </SPAN><BR /><BR /><SPAN>Any help would be much appreciated!!!!!!!!</SPAN></BODY></HTML> Thu, 26 Jul 2012 13:50:28 GMT https://community.esri.com/t5/mapping-questions/zoom-to-point-in-arcgis10-1-from-command-in-ms/m-p/614370#M6687 KellieLinville 2012-07-26T13:50:28Z