Zoom to Point in ArcGIS10.1 from command in MS Acces 2007

Discussion created by teceng_Linville on Jul 26, 2012
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:


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".

When I run the module, I get an automation error on the 'Set pSelSet = pTable.Select(pQFilter, esriSelectionTypeIDSet, esriSelectionOptionNormal, Nothing)' line.

Has anyone tried this connection in ArcGIS10? I am using the VBA Visual Basic Editor.

Any help would be much appreciated!!!!!!!!