Latest Contributions by BrianLeroux

There is a tool called Export Feature Attribute to ASCII that I just tried for the first time a moment ago.  You might look at that, and then see if you can figure out a way to automate importing that into access.  Certainly you could import it manually... Good Luck! Joe- Thanks mentioning that tool. I was able to develop a workflow as follows. Import policies to my DB and have a query run that selects only the new policies. I have a model that uses that query to geocode and return an ASCII file to a specific location. I then import the ASCII file into DB and a query appends the new records to my previously geocoded policies. There are a few manual steps but better than geocoding hundreds of thousands of records monthly. I may be able to even update this weekly.. Thanks again!! ... View more

Donna - Good news. It did actually work. I had the old add-in stuck in cache and my updated code didn't go through.  Thanks for your help.. searchCriteria.WhereClause = "File_Numbe LIKE'%" & SrchTxt & "%'" Try     Dim rows As RowCollection = layer.Table.Search(searchCriteria) ... View more

Donna- That did not work for me. It allows me to search for an exact match put does not work for a partila match. ie- I can search for 1234 and find the file but if i try 12 it does not find 1234. Thanks. Brian ... View more

Thanks Joe. I probably could have worder that better. I will keep digging to see what i can come up with. ... View more

Joe- That does help a little bit. I already have an odbc connection to the access database. I actually use it in a model to geocode the addresses and output to a file geodatabase. I can't figure out how to geocode back to teh access database. Is there any documentation on that? Does it matter that I am using an access 2007 accdb? ... View more

Probably not your issue but i figured I would share. I had a computer where the My Documents was pointed to a location I did not have permissions to. The application will crash in this isntance as it is trying to create and ArcGIS Explorer folder somewhere where it can't. ... View more

I encountered same problem. Because, I have already added add-in to ArcGIS Explorer.  Error message said that the assenbly '***' has already loaded from a different location. When I delete the add-in that is already added, I can load add-in. Your computer already has add-in? Please look at the following on your computer. C:\Documents and Settings\<User Name>\Application Data\ESRI\arcgis explorer\AddIns ArcExplorer can only load your add-ins once. If you manually add the add-in to your application and then try to load it from a config you will get the error. If you will be using the app config with the add-ins already added just remove them from your ArcExplorer Resouces - Manage Add-ins. ... View more

You need to place your add-in on a tab to reference it. Here is how I usually do it. Go in and modify your config. Click customizations in the left column (right above add-ins). Click "Tabs" and click "Add New" from the menu on the right. Name it whatever you want. Click that new tab and the click "New Group" Name that whatever you want. Click that new group and select "Add Custom Control" from the right hand column. Click "Choose File" to select your add in. You should then be able to see your tools under the tab you created. There are also options available to set when and where you see the tab but you canplay around with that later. Let me know if you have any questions. ... View more

Donna- Actually this thread started yesterday. I think you were looking at my "joined date". Anyhow, I have still not found a solution and am still investigating. ... View more

Thanks Margo. Unfortunately it did not work. ... View more

If you are familiar with the .NET SDK, I use the following code in an add-in to export items from a data grid view. I implemented this in the Query Features sample provided with the SDK. Private Sub buttonExport_Click(ByVal sender As System.Object, _           ByVal e As System.EventArgs) Handles buttonExport.Click         Dim xlApp As Microsoft.Office.Interop.Excel.Application         Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook         Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet         Dim misValue As Object = System.Reflection.Missing.Value         xlApp = New Microsoft.Office.Interop.Excel.ApplicationClass         xlWorkBook = xlApp.Workbooks.Add(misValue)         xlWorkSheet = CType(xlWorkBook.Sheets("Sheet1"), Worksheet)         For Each col As DataGridViewColumn In             dataGridView1.Columns             xlWorkSheet.Cells(1, col.Index + 1) = col.HeaderText             For Each rowa As DataGridViewRow In dataGridView1.Rows                 xlWorkSheet.Cells(rowa.Index + 2, col.Index + 1) = rowa.Cells(col.Index).Value             Next         Next         xlApp.Visible = True     End Sub ... View more

I modified the query features add-in sample that came with the SDK. I essentially added an export button which will export the points that were selected to an excel spreadsheet. This will only work with a point layer from a shapefile or geodatabase. Hopefully that is what you are looking for. ... View more