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.
