Latest Contributions by BrianLeroux

I have never had a chance to try this but you may want to look into it. http://www.codeproject.com/KB/grid/multicolumn_sort.aspx ... View more

Donna, The file number is text as it may contain letters. We just call it a number internally as it has always been called that. I am using a variable in the search and can do a UCase there no problem. My issue is that i need to convert the data i am searching through to UCase also and can not find a way to do that. The reason i need to convert is because this tool I am devoloping will not just search my file numbers but any field from any feature I have selected and that may include different cases for text fields. looking at datagridview.fill I do not see any way to specify the columns. I would actually like to do this as well and was planning on looking into it further. I will let you know what i find. ... View more

So my next problems with my Search Add-in.. 1) The search is case sensitive and I would like it not to be. I was going to use UCase on the search string and the column data. However, since I am using table.search there is no select statement to use UCase on the column I am searching. 2) I would like to use LIKE in the where clause for my columns formatted as numbers. That would mean i need to CAST them as a string. As in the case of the issue abouve, since there is no select statement I can't perform a CAST on the field I am searching. Any ideas are appreciated. ... View more

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