Latest Contributions by DuncanHornby

Linda, I had a play with the ITableWindow2 Interface in VBA and found using your code I too could crash ArcMap.  I then played around with the properties and found this combination to work: Public Sub x()     Dim pMXDOC As IMxDocument     Set pMXDOC = ThisDocument     Dim pmap As IMap     Set pmap = pMXDOC.FocusMap     Dim pl As ILayer     Set pl = pmap.Layer(0)     Dim pTW2 As ITableWindow2     Set pTW2 = New TableWindow     With pTW2         Set .Application = Application         Set .Layer = pl         .ShowAliasNamesInColumnHeadings = True         .TableSelectionAction = esriSelectFeatures         .Show True         .ShowSelected = True     End With End Sub I changed the selectionAction  but note I show the TableWindow THEN I show the selected... Duncan ... View more

Robin, You could get into using the GeoProcessor and calling existing tools through the Execute method, this avoids having to know every nuance of ArcObjects. If you want to use the ArcObjects approach then in VBA all you need to do to create a PERSONAL geodatabase is this: Public Sub test()     Dim pWSF As IWorkspaceFactory     Set pWSF = New AccessWorkspaceFactory     Dim pWSN As IWorkspaceName     Set pWSN = pWSF.Create("C:\temp", "pGDB_Test", Nothing, 0) End Sub Duncan ... View more

Jenny, The only thing I spotted with your code is this line: Set EditorEvents = Application.FindExtensionByName("ESRI Object Editor") All the code samples in help use: Dim pID as New UID pID = "esriEditor.Editor" Set m_pEditor = Application.FindExtensionByCLSID(pID) Set EditEvents = m_pEditor Duncan ... View more

You want to use the Interface IStandaloneTableCollection. ... View more

A work around to this problem is this: maintain your data in separate geodatabases or if you are using shapefiles separate folders then you are only ever editing a single workspace. Clunky but this stops you messing up your data. ... View more

Just want to add my "2 cents" to this thread. I have spent the last 2 hours trying to run a spatial join of points to points using the closest match option. Every time it crashed. I tried moving the data to a file geodatabase, to shapefiles, stripped down the fields to the bare minimum, removed domains, you name it I did it. I then asked someone in my office if they could run it to rule out this stupid roaming profile setup we have on our network. Hey presto it worked! AHHH! Anyway the only difference I noticed was that her geoprocessing tool ran as back ground task. I had turned that off along time ago as I think it's pointless and I find the dialog helpful to watch whats going on. So I out of desperation I turned this back on and it worked.  Seriously cheesed off about this... ... View more

It would be great if there was some method on arcpy that purged the memory even if it had a performance hit. If I'm doing large data crunching I'm not going to worry over a few seconds if the data crunching takes several hours.  I was imagining something like: arcpy.ClearMemory Then behind the scenes this would release cursors and objects that are out of scope etc. ... View more

Looking at your code it looks like you are not giving the full path to your file geodatabase.  You set the string targetworkspacepath to simply "melaka.gdb" but where is it? Is it c:\temp or c:\gis\db? I think you need to provide the full path something like c:\temp\melaka.gdb Duncan ... View more

Aaron, I dabbled in developing a geoprocessing tool a few years ago in 9.3 as a way of teaching myself.  Didn't get very far! I have some vague memory that I had to "pack" my parameters. Look at the IGPUtilities interface and PackGPValue method? Just an idea... Duncan ... View more

Michelle, My toolbox in my opinion is not a good place to store anything as it's in my documents which is a directory on the computer so if that blows up you loose the lot! I would recommend you create a folder in the projects folder and call it something simple like GeoProcessing. Then unzip the zip folder into it and you will have your toolbox and the python script in it.  You can then use the catalog window in arcmap to navigate to that folder then you'll see the toolbox, navigate into that for the script tool and at that point you will probably want to go into it properties to ensure the python script it's point to is the one in that folder and not my computer! Duncan ... View more

Michelle, It looks like you got confused and removed the wrong parameter from the wrong thing. I have corrected this and uploaded the script and toolbox in a single zip file. You may need to repoint the toolbox to point to the python script as it may have picked up the location where I stored it on my machine. As you'll see it's not your script that was wrong but the toolbox interface. You were introducing an 8th input which was never used, but your python script only had 7 parameters and it was looking at the table when it really wanted your field. Duncan ... View more

Michelle, Well I think your problem is that your Script is taking 7 inputs but your toolbox interface is asking for 8! You need to set select SRF grid to be of type FeatureLayer and have it loaded in arcmap so you can select it from the drop down. Delete your 7th parameter which is asking for a table, you don't need this as this is output table from your sql query. Finally for your input Selected Join Field "CellID1" set Obtained from to nothing and set it's default value to CellID1. Duncan ... View more

Rebecca, Well you could convert all combination of points into polylines using the Points To Line tool. If you are using model builder then you would probably have a master model with an feature iterator calling a sub-model which builds the polylines.  Again I think this would be easier as a python script. Then you could create a model that loops for each line, rasterizes it using the polyline to raster tool (so only 1 polyline at a time) and use the zonal statistics tool to get the sum of the cells under your rasterized polyline. Duncan ... View more

Rebecca, I'm not so familiar with the type of analysis you are talking (I don't do too much grid analysis). So this is my understanding.  You have a cost layer distance to river. You have point 1 and it is intersecting a cell that is 1 mile from a river, point 2 is on another cell that is 4 miles from a river. So the value you are interested is the difference between these 2 points, which is 3 and then you repeat this analysis for all combinations of points (your 68 points)? If I have understood this correct then you could use the tool Extract Multi Values to Points. This would get all your cost values for each point in 1 hit. You could then use a feature selection iterator to loop through your data doing the pairwise difference (I'm assuming you are ArcGIS 10)? If you can program in Python it may be easier to do the looping in that? Duncan ... View more

I spotted the Android App on the ESRI news feed and tried to download it. I have an HTC wildfire phone which is running the minimum OS that the application requires but it refused to install. I contacted the email address on their homepage and they have not bothered to reply, not brilliant customer support... I will look out for this Panasonic device, sounds good. ... View more