Latest Contributions by DuncanHornby

Duncan, I see you are loading layer files, you are better off using the ILayerFile interface in my opinion. It would certainly simplify your code and that is always a good thing if you are learning code. Also you are wasting your time learning VBA as ESRI have decided to bin it in favour of Python, so you should make the effort to learn that instead. Duncan ... View more

Justin, If your attribute query is selecting more than 1 polygon then you need to bind your selection into a "single" geometry which you pass to an object of type ISpatialFilter. Below is some code that I have used to achieve this, alternatively you could call the SelectByLocation Geo-Processing tool to achieve the same thing... Dim pSelectionSet_Nodes As ISelectionSet     Set pSelectionSet_Nodes = pFeatureSelection_Nodes.SelectionSet     Dim pEnumGeometry As IEnumGeometry     Dim pEnumGeometryBind As IEnumGeometryBind     Set pEnumGeometry = New EnumFeatureGeometry     Set pEnumGeometryBind = pEnumGeometry     pEnumGeometryBind.BindGeometrySource Nothing, pSelectionSet_Nodes     Dim pGeometryFactory As IGeometryFactory     Set pGeometryFactory = New GeometryEnvironment     Dim pGeometry As IGeometry     Set pGeometry = pGeometryFactory.CreateGeometryFromEnumerator(pEnumGeometry)     Dim pSpatialFilter As ISpatialFilter     Set pSpatialFilter = New SpatialFilter     With pSpatialFilter         Set .Geometry = pGeometry         .GeometryField = "SHAPE"         .SpatialRel = esriSpatialRelIntersects     End With     pFeatureSelection_Rivers.SelectFeatures pSpatialFilter, esriSelectionResultNew, False Duncan ... View more

Lorna, Try setting your spatialfilter SpatialRel property to esriSpatialRelIntersects? Duncan ... View more

Matt, What is the format of your data? I tried your code on some random shapefile I have and it worked. Your data isn't some sort of compressed (hence read only) dataset? Duncan ... View more

So you are saying the first time it enters the loop it says false and does not do the split but the next 4 dams do split their respective polylines? May be the issue is with the polyline for the first split, may be it's multipart? Duncan ... View more

Try setting this line: pSelectionSet.Update Nothing, True, pFeatureCursor to: pSelectionSet.Update Nothing, False, pFeatureCursor Also help file says: All edits to features that participate in a Topology or Geometric Network must be bracketed within an edit operation. ... View more

Jeff, Your code above worked and the path did include the cryptic guid number when I displayed it in a message box. I was then able to connect to the LayerFile. So thanks for your help! It's a shame that the ESRI help hints at this method of packaging up other files but provides no example code, if they do it's well hidden! Duncan ... View more

Try calling your "Id" field the traditional name "FID" and set its type to ObjectID and that it is a required field and editable through the IFieldEdit interface? Duncan ... View more

Jeff, Thanks for the advice, I will test that code you suggested. I have looked inside the esriAddin file with winzip and they are in there in. But I'm having second thoughts about where one is actually "going" to get the layerfiles from. I was thinking that you give it a path name (when I finally get it working) that points inside the esriaddin file but the help file talks about setting the copy to output directory. So when you build the visual studio project and look in the bin directory you get the folder with layer files, the esriaddin file then a bunch of other files, but all these are also inside the esriaddin file. Sooo... if for example I take the esriaddin file only and put it in c:\temp am I developing code that is actually looking for a sub folder in c:\temp rather than inside the esriaddin file? Duncan ... View more

This may be an issue with the dpi setting of the machine. People often bump this up as they have difficultly reading text on the screen. In XP goto Control panel > Display > Settings tab > advance button and make sure dpi is normal ... View more

Jill, Why don't you do away with all this painful validation and simply have a date time picker control on your VBA form? Far more user friendly too. When you are in form design mode open the toolbox up right click on toolbox and select additional controls Select the Microsoft Date time picker control 6 (sp4) drag the control onto your form Duncan ... View more

Hi, A "shapefile" in a Personal GeoDatabase is not called a Shapefile it is a "FeatureClass". You would normally use ArcObjects to access a FeatureClass in a Personal GeoDatabase and there are many examples in Help and on the Archived forum. But you want to access the Personal GeoDatabase using OLE, I'm guessing you are developing on a machine that does not have ArcGIS installed on it? If so then the example code below will help you. ' connect to personal geodatabase called C:\Temp\pGDB_Scratch.mdb Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Temp\pGDB_Scratch.mdb" ' Create the connection. Dim oleDbConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection() oleDbConnection.ConnectionString = connectionString ' Open the connection and create a reader. oleDbConnection.Open() ' Create the command to select all fields from a FeatureClass called CompassPoints Dim sqlQuery As String = "SELECT * FROM CompassPoints" Dim oleDbCommand As OleDb.OleDbCommand = New OleDb.OleDbCommand(sqlQuery, oleDbConnection) Dim oleDbDataReader As OleDb.OleDbDataReader = oleDbCommand.ExecuteReader() ' Display data in debug window Do While oleDbDataReader.Read()     Debug.Print(oleDbDataReader("ID").ToString())     Debug.Print(oleDbDataReader("Angle").ToString()) Loop Duncan ... View more

Allen, Good call, I've never used the MultiValue Iterator. Looks like a very useful tool. I've attached a screen shot of my model that would cycle through all the FeatureLayers in the map document clearing any selections. Duncan ... View more

Michal, I totally agree!  Navigating the code gallery is like putting your head in a bucket of mud and choosing a random number! You can log your dissatisfaction here by voting on improving it. http://ideas.arcgis.com/ideaView?id=087300000008JQKAA2 Duncan ... View more