Databases
StackOverflow2013
Usersdbo
USMarwan Marwan مروان مروان
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USMarwan Marwan مروان مروان
    primarykey
    data
    text
    plurals
    1. POHow to Programmatically Sort a DataGridView by Clicking Column Header
      singulars
      1. PTQuestion
    2. POWriting a Simple Logger with Timestamp and Counter in Jython
      singulars
      1. PTQuestion
    3. PO
      singulars
      1. PTAnswer
    1. PODisplaying RowID in Select * (all) Statement
      singulars
      1. PTQuestion
    2. POInclude ROWID in Dataset when Exporting from Toad
      singulars
      1. PTQuestion
    3. POListing all Data Sources and their Dependencies (reports, items, etc) in SQL Server 2008 R2
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COThanks for the quick answer. I guess my question was not very clear. I am trying to scroll up or down the panel programmatically, and not just to the bottom. I just edited my question to reflect that. Sorry about that, but thank you for the helpful information.
      singulars
      1. PO
      1. USMarwan Marwan مروان مروان
    2. CO@SiddharthRout - I figured out how to check if the cell is "frozen" or not, by using the following code: `Function CellIsInFrozenRange(cell As Range)` `Dim inRow As Boolean` `Dim inColumn As Boolean` `If (ActiveWindow.SplitRow > 0) Then` `inRow = Not Intersect(cell, Range(Cells(1, 1),` `Cells(ActiveWindow.SplitRow, 1).End(xlEnd))) Is Nothing` `End If` `If (ActiveWindow.SplitColumn > 0) Then` `inColumn = Not Intersect(cell, Range(Cells(1, 1), Cells(1, ActiveWindow.SplitColumn).End(xlDown))) Is Nothing` `End If` `CellIsInFrozenRange = (inRow Or inColumn)` `End Function`
      singulars
      1. POHow to determine if a worksheet Cell is Visible/Displayed in VBA?
      1. USMarwan Marwan مروان مروان
    3. CO@SiddharthRout - I would consider cell A4 as being visible. Some background on what I'm trying to accomplish, I need to find the LEFT and TOP of a particular cell. So I need to iterate through the cells to it's left and through the cells above it. I need to check if those cells are visible, and if they are, I need to sum their width (or height). The problem that I'm running into right now, is that some of the cells are frozen, and do not show up as part of the visible range. I'm not sure how to deal with that. Any help or suggestions?
      singulars
      1. POHow to determine if a worksheet Cell is Visible/Displayed in VBA?
      1. USMarwan Marwan مروان مروان
 

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