Latest Contributions by RichardFairhurst

Press the Windows button on your computer (lower left corner of the Windows task bar), press the ArcGIS application group, then press the Python Command Prompt application to open a command prompt window.  Type Idle and press Enter to start Idle (Python GUI application).  From the File menu create a New File or use the shortcut Ctrl-N.  Paste the code into the file.  From the File menu Save (Ctrl-S shortcut) the file in the directory you want.  Give the file the name you want and make sure to put the .py extension at the end.  You can run the file from the Run menu Run Module (F5 shortcut).  If there are errors they will be shown in the main Idle window. You can use this .py file to schedule a weekly task using the Windows Task Manager that will run automatically at the date and time you specify.  For the program script portion of the action use (keep in double quotes and replace yourusername with your actual user name): "C:\Users\yourusername\AppData\Local\Programs\ArcGIS Pro\bin\Python\envs\arcgispro-py3\pythonw.exe" For the Add arguments put a double quoted string containing the path and file name of your python script.   ... View more

Since the purpose of your join is to transfer data from the table to the feature class, my Blog applies.  If you change the lines of code below based on the comment that precedes them to match your path, table/feature class names, and field names, this code should work to transfer the data.  This code is not set up for versioned SDE data or SDE data that requires an Editor session to make changes, but it could be adapted to deal with that if needed.  This code assumes the concatenation of the 3 fields uniquely identifies each row in the table.  If the concatenated values of the three fields in the table are not unique, only the value from the last table record holding the concatenated value from the three fields will be passed to all of the matching features in the feature class.  The code could be modified to check for concatenated keys in the source table that are not unique and do statistical operations on the value being transferred, like First, Last, Min, Max, Sum, Mean, etc. (depending on the data type of the value being transferred).       from time import strftime print( "Start script: " + strftime("%Y-%m-%d %H:%M:%S")) import arcpy ## Change the path and source table name to match your table sourceFC = r"C:\Path\SourceTable" ## Change the names of the three join fields and the fourth value field sourceFieldsList = ["JoinField1", "JoinField2", "JoinField3", "ValueField"] # Use list comprehension to build a dictionary from a da SearchCursor where the key values are based on 3 separate feilds valueDict = {(r[0],r[1],r[2]):r[3:] for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)} ## Change the path and update feature class name to match your feature class updateFC = r"C:\Path\UpdateFeatureClass" ## Change the names of the three join fields and the fourth value field updateFieldsList = ["JoinField1", "JoinField2", "JoinField3", "ValueField"] with arcpy.da.UpdateCursor(updateFC, updateFieldsList) as updateRows: for updateRow in updateRows: # store the Join value by combining 3 field values of the row being updated in a keyValue variable keyValue = (updateRow[0],updateRow[1],updateRow[2]) # verify that the keyValue is in the Dictionary if keyValue in valueDict: # transfer the value stored under the keyValue from the dictionary to the updated field. updateRow[3] = valueDict[keyValue] updateRows.updateRow(updateRow) del valueDict print( "Finished script: " + strftime("%Y-%m-%d %H:%M:%S"))             ... View more

What is the ultimate purpose of the join?  Is the join primarily being used for transferring data between the feature class and table, creating feature labels, creating layer symbology, or expanding the feature records to show all of the combinations in a one-to-many or many-to-many relationship with the table.  Is the data relationship supposed to refresh in real time as you edit the features and/or the table and maintain performance in a real time map?  Without knowing your specific needs, all I can do is offer a few suggestions and my feeling about their usefulness. The Make Query Table tool can do multi-field joins, but it is not editable, it only shows records that match, it doesn't really refresh and performs badly for large dataset joins.  For real time needs, I would say it is best to concatenate the values of multiple fields into a single field with a delimiter character separator and use that field to do a standard single field join.  The concatenated field can be maintained in real time for both the feature class and the table using a field calculation like expression using Attribute Assistant in an Editor session under ArcMap Desktop and in Pro with Attribute Rules, provided your data is in a geodatabase that you can customize. If the multi-field join is being used for doing Geoprocessing data transfer operations, see the Creating a Multi-Field Python Dictionary Key to replace a Concatenated Join Field section in my Turbo-Charging Data Manipulation with Python Cursors and Dictionaries Blog. Since your data is in SDE, perhaps creating a view using the underlying database would be your best bet, although I have no real experience in setting up enterprise database views. ... View more

This blog provides a method of data transfer which in its simplest form loads a dictionary from a source and then uses an updateCursor on the target to transfer values where each dictionary key value in the source has an identical matching key value in your target.  It sounds like you are wanting to do a slightly more advanced version of transfer where you are summarizing values from the source and transferring them to the target where a many to one relationship exists between the source and the target on the key field.  This can be done, and the closest example I provide in the blog to your use case is covered in the Using a Python Dictionary Built using a da SearchCursor to Replace a Summary Statistics Output Table.  However, the example needs substantial modification to achieve the summary equivalent of a Join merge rule that outputs a delimited list of values when multiple features in the source relate to a single feature in the target based on a common attribute key value. I would need to know more about your specific needs to be sure I have clear understanding of what you want to achieve before I could provide you with sample code that fits your scenario. ... View more

I don't see anything in the code you showed that indicates you had two separate tables with a million records each joined together through a common attribute that transferred data from the join table to the target table and compared the time that took to the time it takes using a SearchCursor to upload the source table records to a dictionary and then transfer them to another table based on a common join field per the code in my /blogs/richard_fairhurst/2014/11/08/turbo-charging-data-manipulation-with-python-cursors-and-dictionaries.  My issue has nothing to do with processing updates between different fields within the output of a SpatialJoin involving a million records, which is what your code appears to be doing.  I am convinced that the CalculateFields tool is better than a da.UpdateCursor when calculations need to occur on multiple fields within a single table or successive single field calculations, but that is a minor issue when compared to the time it takes to transfer data between two separate large tables to synchronize a target table to match the values in a source table on multiple fields. Also, I find that frequently the target table cannot be duplicated in memory.  At least in my case, I often need to transfer data from a working dataset to another dataset that cannot be deleted or replaced, only updated.  Since writing to data stored on disk appears to add substantial time to the process that only makes finding the best performing operation for this kind of work even more critical. ... View more

While I do not doubt that the Calculate Fields tool will update multiple fields in a single table faster than a da cursor for the reasons you state, nothing you have said gives me confidence that the Calculate Fields tool used on two joined tables outperforms a dictionary and a da cursor.  In the time the Field Calculator for a single field is still preparing to actually write its first value to the target table on a 1 million record table to 1 million record table join with attribute indexes on both joined fields (the green progress bar does not even start showing any progress for more than 20 to 40 minutes), the dictionary has read all of the records and multiple field values of the source 1 million records, the dictionary matches the current da UpdateCursor record on the join field nearly instantaneously and the da cursor has written all of the field values to the target table, even if no attribute index exists on either table.  Is there any improvement of how the join is processed by the Calculate Fields tool?  If not, the dictionary and cursor is the way to go.  The dictionary  and da.UpdateCursor technique also lets me read from multiple source tables and perform all of their independent joins/matches and write all of their values to the target table in a single UpdateCursor pass.  I believe in that situation the advantage you have mentioned is taken away.  With a minor change to the code, records in the target table can first be compared to the dictionary record and limit updates to only those records that have actually changed, which can dramatically speed up the performance when only a few hundred or thousand records out of millions actually need updates.  Parallel dictionaries can be used to gather records that need to be deleted or inserted into the target table so that it will match the source table and those operations can be perfored immediately after the UpdateCursor is completed.  The dictionary can also act as a Summarize tool if necessary to transfer averages, sums, etc. if needed without using that tool prior to doing the data transfer.   I use all of the above options in my scripts and more. For those who are comfortable with advanced python programming the sheer number of possible variations the dictionary and da cursor technique can be adapted and optimized to handle should make it at least competitive if not preferable to any set of chained geoprocessing tools that can accomplish what it can do. Also, where was this tool 6 years ago (and the many years before that when I needed a solution to this problem, but hadn't come across one) when my only option was to learn about dictionaries and I wrote all of my data transfer scripts. The 6 years of fantastic performance gains the dictionary and da.UpdateCursor technique gave me has changed my entire career and was the only practical way for me to really manage my large feature class and table data transfers during that time.  For someone who has never written a script before for data transfers like this the Calcualte Fields tool might be their first choice, but how does it hold up for a user like me that would have to break and rewrite dozens of very large and complex scripts if I wanted to incorporate the Calculate Fields tool as a dictionary and da cursor replacement?  To make it worth my while to rewrite my scripts you have to give me much more of a reason to believe that this new tool is a better solution after all that effort that will save me even more time if I use it in my scripts handling large data transfers among two or more tables going forward. ... View more

The slowest approach for updating a single field is to use two embedded cursors, since the number of records read from the two tables are multiplied by each other (100K x 100K = 10,000,000,000 records).  The join and calculate field approach is easy to set up and apparently does use memory to optimize the calculation if the Join fields in both the source and target have an attribute index, so I use it when I am doing one time calculations and I am willing to wait about 5 to 10 times longer than the Turbo Charging approach.  If either table does not or cannot have an attribute index on the join field, the join and calculate field approach is not worth doing.  Anytime I am scripting a process that will have to run repeatedly it is always worth my time to set up and use the Turbo Charging approach, which reads each record of the two tables only once (100K + 100K = 200K records) and is the fastest at loading the source table into memory and updating the target records.  Attribute indexes on the Join fields have little to no effect on the Turbo Charging approach, but may slow the transfer if they are on the update fields for both the join and calculate approach and the turbo charging approach, so I try to add them after the data transfer is complete. Another optimization of my turbo charging approach I use a lot is to add an if condition that compares the update values in the dictionary to the current value of the target and only perform updates on the records in the target table that have changed, especially when I know that only a small number of records have actually changed since the last update.  Doing comparisons in memory and targeting only the changed records is much faster than writing values to every record of the target table when relatively few values have actually changed. ... View more

Since the release of AcrMap 10.1 I only use joins that involve One to Many or Many to Many relationships when I store all tables in the same Geodatabase and export them with the joins in place.  If a scheduled scripting approach is acceptable for solving my problem, I have used the technique in my /blogs/richard_fairhurst/2014/11/08/turbo-charging-data-manipulation-with-python-cursors-and-dictionaries blog to combine multiple features/tables in memory to generate either inner or outer join forms at my discretion and output them.  The code can get tricky as you need to employ different embedded for loop code combinations and json like structures to get the different join effects, but the performance is excellent.  In many respects the code resembles the requirements of Access to build up the joins using multiple chained queries if your inner and outer join relationships become too ambiguous to do in a single query as you add more and more tables.  However, I have not discovered a visualization solution that responds to edits in the source normalized data in real time when One to Many or Many to Many relationships are involved. At the same time, I find that Access often requires me to hit the F5 key to refresh the query when I use these kinds of chained queries, so in theory a similar manual refresh approach from an addin toolbar could trigger a script based on my blog to get updates from the source data in near real time and output to an inmemory or stored feature class displayed in a layer.  I would have to have a use case laid out for me and time to experiment with it to see how well that would work. ... View more

In order to do this you would need to have four fields in your pipe feature, the pipe type that relates to your separate table, a field to store the rate on the feature from the separate table, the length of the pipe, and the final pipe cost.  Then you could use the Update Linked Record method of attribute assistant to respond to attribute or manual changes to populate the rate field from the separate table when the user entered a valid pipe type, followed by an Expression method of attribute assistant to respond to geometry. attribute or manual changes of populate the cost field based on the rate and length.  Each Attribute Assistant method is stored in a separate record of the DynamicValue table.and they are executed in the order that the records are stored from the first record to the last record, so methods can be chained together in a logical sequential order. You cannot write an Expression that uses the separate table directly and avoid the need to store the rate in its own field on each pipe feature, but in many ways it is better to store the rate for each pipe individually than make a user have to execute a join/relate on the related table or divide the cost of a pipe of each pipe type by the length to discover what rates were used anyway.  This also ensures that you would be able to tell if all pipe costs have been updated to the current rate if that is part of your business logic or would show which pipes used historic rates and which used current rates if the pipes represent both past and current jobs that paid different rates for the same materials. ... View more

I have designed a set of toolbars for my Addin that let me enter a record ID value that executes an attribute query on one of two different Access tables and then displays the results of the query in combo boxes on multiple toolbars.  This lets the user confirm that they have chosen the correct record for editing prior to making any updates.  All of these combo boxes are editable since there is an apparent bug that prevents the combo box from displaying its selected value when it is not editable.  As a result, I have added code in the onFocus method of some of the combo boxes that fires prior to the combo box losing focus that ensures that the user is ultimately not allowed to make changes to the value returned or is only allowed to type in values that are in the combo box drop down list when that is a data validation requirement of the field. Here is what my toolbars look like when ArcMap starts.  The toolbars I have designed display data from Access tables that collect information for my department's Traffic Control Device Inventory (TCDI) which represent the location and configuration of signs and pavement markings on our roadways.  The user is expected to enter numeric ID values into the TCDI ID combo box to retrieve records from Access. I have made it possible for the user to chose to retrieve records from one of two different Access Tables that have identical schemas that work with the other combo boxes that display the retrieved record's field values.  I did not find a way to change the toolbar headings or combo box captions, tooltips and help instructions at runtime, so if I let the user chose between tables with different schemas I believe would have to add code to the addin that would turn on and off different toolbars or swap out the combo boxes from the toolbars depending on the table the user chose.  If anyone finds a way to change the toolbar and combo box captions, etc. at runtime, please let me know. Here is what the toolbars look like when the user enters a valid TCDI ID value (477) of a record that exists in the tblTCDIActive Access table into the TCDI ID combo box. Here is what the toolbars look like when the user enters an invalid TCDI ID value (913) of a record that does not exist in the tblTCDIActive Access table into the TCDI ID combo box.  I have included a Query Result (QRslt) combo box to always let the user know whether the record was or was not found regardless of what the Access table query returns. The user can switch to the tblTCDIInactive table to see if the TCDI ID which was invalid in the tblTCDIActive was valid in the tblTCDIInactive table.  In this example TCDI ID 913 was found in the tblTCDIInactive Access table. I have purposefully chosen to make this example display records based on a single field that contains unique values for each record for simplicity's sake.  However, it is possible to build more sophisticated queries for retrieving records based on multiple fields where the drop down options of the other combo boxes could be changed by the choices the user made in more and more fields until the user has entered enough information based on those drop downs to display a single record or they have entered enough information to define a set of records represented by the drop down values in the field that the user didn't make a selection that you would be willing to consider complete for updating.  So the possibilities for guiding your users to the records they are looking for is really up to you and the level of complexity you are willing to deal with in writing your code. At this point, since everyone has different workflow requirements, I have not included any code in the addin code below that executes an update query. However, there are many different options for designing additional addin code in tools, buttons or the combo boxes' onFocus methods to execute one or more update queries from within ArcMap on the chosen Access table record to change different sets of attributes.  The code could also optionally trigger message boxes that make the user confirm their edits prior to executing any update query.  I will be adding code that performs update queries in the actual toolbars I will be deploying to my users, so if you need help adding this functionality I should be able to offer suggestions and guidance on how to do that. The cbxUser_Comment class at the bottom of the code controls the TCDI ID combo box, which handles the Access table query that updates most of the other combo boxes (sorry for basing this example on a schema with a peculiar history for the main ID field name).  I do expect to refine this code to improve the field validation routines after I test it with my actual users, but the code seems to work well enough to begin that testing.  I may post back corrections to this code once I have seen how my users try to break my validation rules or if I discover any oddities I did not expect in the way the combo box controls behave. import arcpy import pythonaddins import getpass from datetime import datetime import pyodbc class CaptureCoordinateTool(object):   ### See code posted previously in this blog class cbxAccessTable(object):     """Implementation for Capture_Coordinate_addin.cbxAccessTable (ComboBox)"""     # instantiate class variables for a case insensitive dictionary of items and last valid value that matched the item list     def __init__(self):         self.items = [u"tblTCDIActive", u"tblTCDIInactive"]         self.upperDict = {i.upper():i for i in self.items}         self.editable = True         self.enabled = True         self.dropdownWidth = 'tblTCDIInactiveWW'         self.width = 'tblTCDIInactiveWW'         self.value = self.items[0]         self.oldValue = self.value     def onSelChange(self, selection):         pass     def onEditChange(self, text):         if text.upper() in self.upperDict:             self.oldValue = self.upperDict[text.upper()]         print("onEditChange fired. Text = " + text + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         pass     def onFocus(self, focused):         if focused == False:             if not self.value.upper() in self.upperDict:                 # The value entered by the user was not a case insensitive match                 # Prior to fully losing focus the combo box value is changed to the                 # last valid case sensitive value the user chose or entered                 self.value = self.oldValue             else:                 # The value entered by the user was a case insensitive match                 # Prior to fully losing focus the combo box value is set to make sure                 # the value exactly matches the case sensitive item in the items list                 self.value = self.upperDict[self.value.upper()]         print("onFocus fired. focused = " + str(focused) + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass             class cbxCategory(object):     """Implementation for Capture_Coordinate_addin.cbxCategory (ComboBox)"""     def __init__(self):         self.items = [u"", u"MARKING", u"SIGN"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWW'         self.width = 'WWWWWW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxCode(object):     """Implementation for Capture_Coordinate_addin.cbxCode (ComboBox)"""     def __init__(self):         self.items = [u"", u"STOP", u"BIKE"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWWWWWW'         self.width = 'WWWWWWWWWWWW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxColor(object):     """Implementation for Capture_Coordinate_addin.cbxColor (ComboBox)"""     def __init__(self):         self.items = [u"", u"W", u"Y", u"R"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WW'         self.width = 'WW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxDirection(object):     """Implementation for Capture_Coordinate_addin.cbxDirection (ComboBox)"""     def __init__(self):         self.items = [u"", u"-", u"E", u"N", u"S", u"W"]         self.upperDict = {i.upper():i for i in self.items}         self.editable = True         self.enabled = True         self.dropdownWidth = 'WW'         self.width = 'WW'         self.value = self.items[0]         self.oldValue = self.value     def onSelChange(self, selection):         pass     def onEditChange(self, text):         if text.upper() in self.upperDict:             self.oldValue = self.upperDict[text.upper()]         print("onEditChange fired. Text = " + text + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         pass     def onFocus(self, focused):         if focused == False:             if not self.value.upper() in self.upperDict:                 self.value = self.oldValue             else:                 self.value = self.upperDict[self.value.upper()]         print("onFocus fired. focused = " + str(focused) + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxDistance(object):     """Implementation for Capture_Coordinate_addin.cbxDistance (ComboBox)"""     def __init__(self):         self.items = [u"", u"0", u"100"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWW'         self.width = 'WWWWW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxFacing(object):     """Implementation for Capture_Coordinate_addin.cbxFacing (ComboBox)"""     def __init__(self):         self.items = [u"", u"-", u"E", u"N", u"S", u"W"]         self.upperDict = {i.upper():i for i in self.items}         self.editable = True         self.enabled = True         self.dropdownWidth = 'WW'         self.width = 'WW'         self.value = self.items[0]         self.oldValue = self.value     def onSelChange(self, selection):         pass     def onEditChange(self, text):         if text.upper() in self.upperDict:             self.oldValue = self.upperDict[text.upper()]         print("onEditChange fired. Text = " + text + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         pass     def onFocus(self, focused):         if focused == False:             if not self.value.upper() in self.upperDict:                 self.value = self.oldValue             else:                 self.value = self.upperDict[self.value.upper()]         print("onFocus fired. focused = " + str(focused) + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxFlag(object):     """Implementation for Capture_Coordinate_addin.cbxFlag (ComboBox)"""     def __init__(self):         self.items = [u"", u"ACTIVE", u"INACTIVE"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWW'         self.width = 'WWWWWW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxG_Latitude(object):     """Implementation for Capture_Coordinate_addin.cbxG_Latitude (ComboBox)"""     def __init__(self):         self.items = [u"", u"32"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWWWWWWWWWWWWWWWWWWW'         self.width = 'WWWWWWWWWW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxG_Longitude(object):     """Implementation for Capture_Coordinate_addin.cbxG_Longitude (ComboBox)"""     def __init__(self):         self.items = [u"", u"-116"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWWWWWWWWWWWWWWWWWWW'         self.width = 'WWWWWWWWWW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxInt_Dir(object):     """Implementation for Capture_Coordinate_addin.cbxInt_Dir (ComboBox)"""     def __init__(self):         self.items = [u"", u"-", u"E", u"N", u"S", u"W", u"1", u"2", u"3", u"4", u"5", u"6"]         self.upperDict = {i.upper():i for i in self.items}         self.editable = True         self.enabled = True         self.dropdownWidth = 'WW'         self.width = 'WW'         self.value = self.items[0]         self.oldValue = self.value     def onSelChange(self, selection):         pass     def onEditChange(self, text):         if text.upper() in self.upperDict:             self.oldValue = self.upperDict[text.upper()]         print("onEditChange fired. Text = " + text + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         pass     def onFocus(self, focused):         if focused == False:             if not self.value.upper() in self.upperDict:                 self.value = self.oldValue             else:                 self.value = self.upperDict[self.value.upper()]         print("onFocus fired. focused = " + str(focused) + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxLane_Number(object):     """Implementation for Capture_Coordinate_addin.cbxLane_Number (ComboBox)"""     def __init__(self):         self.items = [u"", u"1", u"2", u"3", u"4", u"5", u"6", u"-99", u"99"]         self.upperDict = {i.upper():i for i in self.items}         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWW'         self.width = 'WWWW'         self.value = self.items[0]         self.oldValue = self.value     def onSelChange(self, selection):         pass     def onEditChange(self, text):         if text.upper() in self.upperDict:             self.oldValue = self.upperDict[text.upper()]         print("onEditChange fired. Text = " + text + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         pass     def onFocus(self, focused):         if focused == False:             if not self.value.upper() in self.upperDict:                 self.value = self.oldValue             else:                 self.value = self.upperDict[self.value.upper()]         print("onFocus fired. focused = " + str(focused) + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxLastAction_Date(object):     """Implementation for Capture_Coordinate_addin.cbxLastAction_Date (ComboBox)"""     def __init__(self):         self.items = [u"", u"01/11/2020"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWW'         self.width = 'WWWWWW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxLast_User(object):     """Implementation for Capture_Coordinate_addin.cbxLast_User (ComboBox)"""     def __init__(self):         self.items = [u"", u"ACTIVE", u"INACTIVE"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWW'         self.width = 'WWWWWW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxLength(object):     """Implementation for Capture_Coordinate_addin.cbxLength (ComboBox)"""     def __init__(self):         self.items = [u"", u"0", u"24", u"36", u"48"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWW'         self.width = 'WWWWWW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxMaintDist(object):     """Implementation for Capture_Coordinate_addin.cbxMaint_Dist (ComboBox)"""     def __init__(self):         self.items = [u"", u"11", u"12", u"13", u"14", u"15", u"16", u"17", u"18", u"19", u"20"]         self.upperDict = {i.upper():i for i in self.items}         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWW'         self.width = 'WWW'         self.value = self.items[0]         self.oldValue = self.value     def onSelChange(self, selection):         pass     def onEditChange(self, text):         if text.upper() in self.upperDict:             self.oldValue = self.upperDict[text.upper()]         print("onEditChange fired. Text = " + text + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         pass     def onFocus(self, focused):         if focused == False:             if not self.value.upper() in self.upperDict:                 self.value = self.oldValue             else:                 self.value = self.upperDict[self.value.upper()]         print("onFocus fired. focused = " + str(focused) + ". self.value = " + self.value + ". oldValue = " + self.oldValue)         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxMedian(object):     """Implementation for Capture_Coordinate_addin.cbxMedian (ComboBox)"""     def __init__(self):         self.items = [u"", u"N", u"Y"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WW'         self.width = 'WW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxPrimary_(object):     """Implementation for Capture_Coordinate_addin.cbxPrimary_ (ComboBox)"""     def __init__(self):         self.items = [u"", u"A ST"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWWWWWWWWWWWWWWWWWWW'         self.width = 'WWWWWWWWWWWWWW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxQueryResult(object):     """Implementation for Capture_Coordinate_addin.cbxQueryResult (ComboBox)"""     def __init__(self):         self.items = [u"Device Found", u"Device Not Found"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWW'         self.width = 'WWWWWWWW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxRdNumber(object):     """Implementation for Capture_Coordinate_addin.cbxRdNumber (ComboBox)"""     def __init__(self):         self.items = [u"", u"M0000"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWW'         self.width = 'WWWWWWWW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxRemarks(object):     """Implementation for Capture_Coordinate_addin.cbxRemarks (ComboBox)"""     def __init__(self):         self.items = [u"", u"Remove This Devise"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWWWWWWWWWWWWWWWWWWW'         self.width = 'WWWWWWWWWWWWWW'         self.value = u""     def onSelChange(self, selection):         pass     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()         pass     def onEnter(self):         pass     def refresh(self):         pass class cbxSecondary(object):     """Implementation for Capture_Coordinate_addin.cbxSecondary (ComboBox)"""     def __init__(self):         self.items = [u"", u"A ST"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWWWWWWWWWWWWWWWWWWW'         self.width = 'WWWWWWWWWWWWWWW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxSize1(object):     """Implementation for Capture_Coordinate_addin.cbxSize1 (ComboBox)"""     def __init__(self):         self.items = [u"", u"0", u"24", u"36", u"48"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWW'         self.width = 'WWWW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxSize2(object):     """Implementation for Capture_Coordinate_addin.cbxSize2 (ComboBox)"""     def __init__(self):         self.items = [u"", u"0", u"24", u"36", u"48"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWW'         self.width = 'WWWW'         self.value = ""     def onSelChange(self, selection):         self.refresh()     def onEditChange(self, text):         pass     def onFocus(self, focused):         self.refresh()     def onEnter(self):         pass     def refresh(self):         pass class cbxUser_Comment(object):     """Implementation for Capture_Coordinate_addin.cbxUser_Comment (ComboBox)"""     def __init__(self):         self.items = ["", "1"]         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWW'         self.width = 'WWWWWWW'         self.value = u""         self.oldValue = self.value     def onSelChange(self, selection):         pass     def onEditChange(self, text):         if text.isdigit() or text == "":             self.oldValue = text         pass     def onFocus(self, focused):         if focused == False and not self.value.isdigit():             self.value = self.oldValue             self.refresh()         if focused == False and self.value.isdigit():             user_comment = int(self.value)             conn_str = (                 r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};'                 r'DBQ=\\agency\agencydfs\Annex\Files\TRAFFIC\TRAFFICDB\TRAFFICDB\TRAFFICDB.accdb;'                 ) # set up a connection string for connecting to an Access accdb database             cnxn = pyodbc.connect(conn_str) # connect to the Access accdb database             crsr = cnxn.cursor() # create a cursor from the connection             crsr.execute("SELECT User_Comment, MAINT_DIST, RDNUMBER, PRIMARY_, DISTANCE, DIRECTION, SECONDARY, INT_DIR, FACING, CODE, LANE_NUMBER, COLOR, SIZE1, SIZE2, LENGTH, MEDIAN, REMARKS, LASTACTION_DATE, LAST_USER, CATEGORY, FLAG, G_Longitude, G_Latitude FROM {} WHERE User_Comment = {}".format(cbxAccessTable.value, user_comment)) # Execute a query to find any records that match the user_comment entered             row = crsr.fetchone() # fetch the first record (there should only be none or one record)             if row: # If a row was found update the combo boxes                 print(row)                 cbxQueryResult.value = u"{} Found".format(self.value)                 cbxMaint_Dist.value = u"" if row.MAINT_DIST == None else str(row.MAINT_DIST)                 cbxRdNumber.value = u"" if row.RDNUMBER == None else row.RDNUMBER                 cbxPrimary_.value = u"" if row.PRIMARY_ == None else row.PRIMARY_                 cbxDistance.value = u"" if row.DISTANCE == None else str(row.DISTANCE)                 cbxDirection.value = u"" if row.DIRECTION == None else row.DIRECTION                 cbxSecondary.value = u"" if row.SECONDARY == None else row.SECONDARY                 cbxInt_Dir.value = u"" if row.INT_DIR == None else row.INT_DIR                 cbxFacing.value = u"" if row.FACING == None else row.FACING                 cbxCode.value = u"" if row.CODE == None else row.CODE                 cbxLane_Number.value = u"" if row.LANE_NUMBER == None else str(row.LANE_NUMBER).replace(".0","")                 cbxColor.value = u"" if row.COLOR == None else row.COLOR                 cbxSize1.value = u"" if row.SIZE1 == None else str(row.SIZE1).replace(".0","")                 cbxSize2.value = u"" if row.SIZE2 == None else str(row.SIZE2).replace(".0","")                 cbxLength.value = u"" if row.LENGTH == None else str(row.LENGTH).replace(".0","")                 cbxMedian.value = u"" if row.MEDIAN == None else row.MEDIAN                 cbxRemarks.value = u"" if row.REMARKS == None else row.REMARKS                 cbxLastAction_Date.value = u"" if row.LASTACTION_DATE == None else row.LASTACTION_DATE.strftime("%m/%d/%Y")                 cbxLast_User.value = u"" if row.LAST_USER == None else row.LAST_USER                 cbxCategory.value = u"" if row.CATEGORY == None else row.CATEGORY                 cbxFlag.value = u"" if row.FLAG == None else row.FLAG                 cbxG_Longitude.value = u"" if row.G_Longitude == None else str(row.G_Longitude)                 cbxG_Latitude.value = u"" if row.G_Latitude == None else str(row.G_Latitude)                 cbxQueryResult.refresh()                 cbxMaint_Dist.refresh()                 cbxRdNumber.refresh()                 cbxPrimary_.refresh()                 cbxDistance.refresh()                 cbxDirection.refresh()                 cbxSecondary.refresh()                 cbxInt_Dir.refresh()                 cbxFacing.refresh()                 cbxCode.refresh()                 cbxLane_Number.refresh()                 cbxColor.refresh()                 cbxSize1.refresh()                 cbxSize2.refresh()                 cbxLength.refresh()                 cbxMedian.refresh()                 cbxRemarks.refresh()                 cbxLastAction_Date.refresh()                 cbxLast_User.refresh()                 cbxCategory.refresh()                 cbxFlag.refresh()                 cbxG_Longitude.refresh()                 cbxG_Latitude.refresh()             else:                 print("No Device Found")                 cbxQueryResult.value = u"{} Not Found".format(self.value)                 cbxMaint_Dist.value = u""                 cbxRdNumber.value = u""                 cbxPrimary_.value = u""                 cbxDistance.value = u""                 cbxDirection.value = u""                 cbxSecondary.value = u""                 cbxInt_Dir.value = u""                 cbxFacing.value = u""                 cbxCode.value = u""                 cbxLane_Number.value = u""                 cbxColor.value = u""                 cbxSize1.value = u""                 cbxSize2.value = u""                 cbxLength.value = u""                 cbxMedian.value = u""                 cbxRemarks.value = u""                 cbxLastAction_Date.value = u""                 cbxLast_User.value = u""                 cbxCategory.value = u""                 cbxFlag.value = u""                 cbxG_Longitude.value = u""                 cbxG_Latitude.value = u""                 cbxQueryResult.refresh()                 cbxMaint_Dist.refresh()                 cbxRdNumber.refresh()                 cbxPrimary_.refresh()                 cbxDistance.refresh()                 cbxDirection.refresh()                 cbxSecondary.refresh()                 cbxInt_Dir.refresh()                 cbxFacing.refresh()                 cbxCode.refresh()                 cbxLane_Number.refresh()                 cbxColor.refresh()                 cbxSize1.refresh()                 cbxSize2.refresh()                 cbxLength.refresh()                 cbxRemarks.refresh()                 cbxLastAction_Date.refresh()                 cbxLast_User.refresh()                 cbxCategory.refresh()                 cbxFlag.refresh()                 cbxG_Longitude.refresh()                 cbxG_Latitude.refresh()             crsr.close() # close the accdb cursor             cnxn.close() # close the accdb connection         pass     def onEnter(self):         pass     def refresh(self):         pass‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I know this is an old thread, but here is a solution that allows a combo box to be editable so that the user chosen value appears in the combo box while still making sure that the final value entered by the user exactly matches an item from the items list before the combo box fully loses focus.  If the user typed any value that is a case insensitive match with any item in the items list the value will be converted to the fully case sensitive version of that item.  If the user leaves the combo box after entering any value that is not a case insensitive match to any of the items in the items list the combo box value will be set back to the last valid case sensitive value the user or the addin code entered into the combo box. class cbxAccessTable(object): """Implementation for Capture_Coordinate_addin.cbxAccessTable (ComboBox)""" # initialize instance variables for a case insensitive dictionary of items and # for the last valid value the user chose or typed that matched the items list def __init__(self): self.items = [u"tblTCDIActive", u"tblTCDIInactive"] self.upperDict = {i.upper():i for i in self.items} self.editable = True self.enabled = True self.dropdownWidth = 'tblTCDIInactiveWW' self.width = 'tblTCDIInactiveWW' self.value = self.items[0] self.oldValue = self.value def onSelChange(self, selection): pass def onEditChange(self, text): pass def onFocus(self, focused): if focused == False: if not self.value.upper() in self.upperDict: # The value entered by the user was not a case insensitive match # Prior to fully losing focus the combo box value is changed to the # last valid case sensitive value the user chose or entered self.value = self.oldValue self.refresh() else: # The value entered by the user was a case insensitive match # Prior to fully losing focus the combo box value is set to make sure # the value exactly matches the case sensitive item in the items list self.value = self.upperDict[self.value.upper()] self.oldValue = self.value self.refresh() print("onFocus fired. focused = " + str(focused) + ". self.value = " + self.value + ". oldValue = " + self.oldValue) pass def onEnter(self): pass def refresh(self): pass‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ If I want to change the items list of this class from another control, I need to not only set both the cbxAccessTable.items and cbxAccessTable.value properties, but also the cbxAccessTable.upperDict property like this: if selection == "New Items": cbxAccessTable.items = [u"tblTCDIActive".u"tblTCDIInactive",u"tblTCDIAll"] cbxAccessTable.upperDict = {i.upper():i for i in cbxAccessTable.items} cbxAccessTable.value = cbxAccessTable.items[0] cbxAccessTable.oldValue = cbxAccessTable.value cbxAccessTable.refresh() elif selection == "Original Items": cbxAccessTable.items = [u"tblTCDIActive".u"tblTCDIInactive"] cbxAccessTable.upperDict = {i.upper():i for i in cbxAccessTable.items} cbxAccessTable.value = cbxAccessTable.items[0] cbxAccessTable.oldValue = cbxAccessTable.value‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ cbxAccessTable.refresh() ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

One possible way to get user input that can control which Access table and records will be selected for editing when the coordinate tool is activated and the maps is clicked would be through addin combo boxes added to one or more toolbars created for the addin that contains the tool.  Communications between all of the toolbars, tools, combo boxes and other controls of the addin should all be able to handled within the addin's python file.  A combo box contains an editable field and a drop-down list. The user can select a value from the drop-down list, which appears at the user's request. If you make the combo box editable, the combo box will include an editable field into which the user can type a value.  One combo box could list the tables in the Access database the user could choose from to edit and other combo boxes could capture the field(s) and value(s) that would complete a where clause for selecting the records that would be edited by the tool.  The drop down list of each combo box can be updated based on choices made in other combo boxes or menus.  Therefore, additional combo boxes could be used to display other table attribute field values when the record selection changes and allow the user to input attribute value changes that would be written to the Access table when the map is clicked by the coordinate tool.  An addin menu could also be created to control whether a record would be edited or inserted and potentially even deleted in the Access table. One possible benefit of this approach is that the combo boxes constantly remain open and the user can control the location of the toolbar(s) to be anywhere on the screen that would help them move back and forth between the locations they click on the map and the combo boxes that will control the Access records they are editing.  The primary downside of this approach is that the ways the combo boxes can be arranged in the toolbar are very limited and labeling the combo boxes can make the toolbar very wide.  However, dividing the addin controls among more than one toolbar may make the arrangement of the combo boxes more flexible and tool tips could potentially be used to reduce the need for labels.  Another possible downside of python addins is that performance will degrade if too many controls are created in the addin that require a lot of code for interacting with each other and if the addin controls trigger a lot of interactions with the Access database, so the addin needs to be streamlined as much as possible to avoid excessive code complexity and data retrievals. The properties available for configuring the combo box are listed in Combo Box class—Help | ArcGIS Desktop. I hope to have time soon to try and implement this addin design and create a coordinate capture tool that can be used to directly edit or create any of the records in several different tables in a Microsoft Access database. ... View more