Databases
StackOverflow2013
Usersdbo
USKimball Robinson
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USKimball Robinson
    primarykey
    data
    text
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. POset table row height
      singulars
      1. PTQuestion
    1. POQuicktest Pro - find first button after matching text
      singulars
      1. PTQuestion
    2. POMS-Excel: How to show the value of a combo box inside a locked cell
      singulars
      1. PTQuestion
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAutomated testing of GUI
      1. USKimball Robinson
      1. VTFavorite
    2. VO
      singulars
      1. POWhat is this pattern called?
      1. USKimball Robinson
      1. VTFavorite
    3. VO
      singulars
      1. POCase-insensitive Glob on zsh/bash
      1. USKimball Robinson
      1. VTFavorite
    1. COMy solution was perhaps not clear from above. You can create two named ranges, one of which is formula-based. A macro can do something like names.add("staticName", Thisworkbook.names("formulaBasedName").refersto) every time you want to update the static named range. The combo box listfillrange can then point at the staticName named range, which will disable the excel bug I noted above.
      singulars
      1. PO
      1. USKimball Robinson
    2. COI can already check for overridden named ranges with "if Range("nameXYZ").Value <> ThisWorkbook.Names("nameXYZ").RefersToRange.Value" in a for loop on "for each nm in thisworkbook.names". And once again, I simply cannot make this work retroactively, and finally I reiterate that the second code sample in my original post circumvents the problem in the newer version--thus, I do not NEED to detect duplicates. In other words, I appreciate your efforts, but you are not solving the correct problem.
      singulars
      1. PO
      1. USKimball Robinson
    3. COI got it working--I had to restart excel to have the event start working. Thanks!! As an interesting side note, as far as I can tell, the newer version doesn't need to check workbooks that are already open--the first workbook opened gets precedence anyway (so if the older version is opened first, the named ranges work correctly for it, and the new version is designed correctly so it works) (Thus, this is only a problem if the old versions get opened second). So I only need to set up the function to check workbooks that open after the most-updated one.
      singulars
      1. PO
      1. USKimball Robinson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload