Latest Contributions by DuncanHornby

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

Will, May be it's something weird to do with your DEM? Try passing a simple vector layer to it first to see it that works? Duncan ... View more

I like your idea and could see a definite place in the market for 1 day licenses. Alternatively the amount you'll end up spending on 1 day licenses (lets face it ESRI will never be cheap) you could buy everything in one system like Manifold. I've never used it but it appears to do everything for a fraction of the price, ... View more

Frank, Have you looked at the help recently? ESRI are forcing people to go the way of Python and have made changes to how VB scripting functions. You need to make some minor changes to you script and they are documented here.  Basically drop your Dim statements. Duncan ... View more

I think Shapefile format does not support nullable values? ... View more

Mono, According to the Help file the 00735 error means you don't have all the parameters set for a tool to run. You could try to validate your model (set any parameters first) and see where it goes white and then drill down to the problem? Duncan ... View more