Latest Contributions by DuncanHornby

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

John, I use PyScripter as my Python development environment, it's very good. OK first you need to create your script and set it up as shown below: # Import system modules import sys, string, os, arcgisscripting # Create the Geoprocessor object gp = arcgisscripting.create(9.3) # Local variables...Try to get the iteration number that the model is on. IterationNum = gp.GetParameterAsText(0) # Do stuff... gp.addmessage("it = " + IterationNum) Now add your script to the tool box and ensure that it has a single parameter of type text. Create your model and set your model to run X times. Drag your script which is now a tool onto your model and expose the parameter and set it's value to %n%. Your script will then be able to use it but be aware that a string is passed to the script. Duncan ... View more

Michael, If your dataset is a shapefile try setting this: arcpy.AddField_management(FootprintFC, "GeoAngle", "DOUBLE", "", "", "", "", "NULLABLE", "NON_REQUIRED", "") to arcpy.AddField_management(FootprintFC, "GeoAngle", "DOUBLE", "", "", "", "", "", "", "") Duncan ... View more

Andrew, The raster you are "joining" the parcel data to, will it not double count all your parcel data? I'm think you'll have raster cells a quarter of a mile away as well as raster cells directly underneath your parcel so that parcel is counted for as many cells under or a quarter of a mile away? Anyway are these parcels non-overlapping (I know nothing about tax parcels)? If so would the Focal Statistics tool achieve what you want? You would rasterize your polygon layer with the value being the count field and then do a Focal statistic on it? The help file has lots of information about the different parameters of the tool. Just an idea, may be not what you want? Duncan ... View more

Change this line: pDatasetName.Name = strInputFileName to pDatasetName.Name = "Sheet1$" This assumes you have accepted the default sheet name. Duncan ... View more