TAB key with DataGrid Control

What I need:
The Datagrid is 2nd in the Tab Sequence.


It seems that the cursor goes somewhere.
When I hit Tab again,  the correct object is in the next sequence.
But, when the datagrid is supposed to have focus,  I CAN'T see the cursor.


The datagrid is unbound.
I can mouse to the grid.


DataGrid2: settings
TabIndex2
TabStop  =  true
TabAction- =  Have tried all

Any help?
fordraiders
LVL 3
FordraidersAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
fordraiders, this might work, in the gotfocus event of datagrid2 put the following instead of the sendkeys stuff:

With DataGrid2
    .Row = .ApproxCount
    .Col = 1
    .EditActive = True
End With

This should position the cursor in the "*" row in column one with the cursor showing.
0
 
Brendt HessSenior DBACommented:
Recommendation:  When the .Gotfocus event fires on your grid, set highlighting on the current row.  Your cursor will be visible then.
0
 
FordraidersAuthor Commented:
bhess1,
Set highlighting?

When I used the mouse cursor to the firstRow , firstCell. and then proceeded to use the tab key ,
When I cycled back around to the grid It then obtained  focus.
However,
When I reached the last cell I got an error message.
"IRowOffset would position you past either end of the rowset, regardless of the cRows value specified; cRowsObtained  is 0"
Thanks
fordraiders

0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
FordraidersAuthor Commented:
bHess1,
When I add a record to the Datagrid(which is what I'am trying to do at this point) . How do I set focus to the row that has the   * as indicating a new record?
Thanks
fordraiders
0
 
Brendt HessSenior DBACommented:
The easiest way would be to trap that error you got (IRowOffset), and add a new row to the grid at that point (DBGrid1.Rows = dbGrid1.Rows+1), then set focus to the new row (DBGrid1.Row = DBGrid.Rows - 2 ' if * line displayed - if not, then use -1)
0
 
FordraidersAuthor Commented:
bHess1,
I donot have a DBGrid.
I have a datagrid.
fordraiders
0
 
FordraidersAuthor Commented:
bHess1,
I donot have a DBGrid.
I have a datagrid.
fordraiders
0
 
FordraidersAuthor Commented:
bHess1,
I have had success(but not complete) so far with the following:

Private Sub DataGrid2_GotFocus()
IF (DATAGRID1.SELBOOKMARKS.COUNT <> 0 THEN
DATAGRID2.SELBOOKMARKS.REMOVE 0
END IF

IF ADODC3.RECORDSET.RECORDCOUNT = 0 _
AND DATAGRID2.ROW = 0 THEN
IF ADODC3.RECORDSET.RECORDCOUNT = 0 _
AND DATAGRID2.ROW = -1 THEN
Datagrid2.selBookmarks.add _ DATAGRID2.BOOKMARK
END IF
END IF
END SUB

I still have to right arrow but, I'am getting there.

If could simulate a LeftMouse click  AND a Left Arrow Keystroke  in the datagrid in a cell,  I could have it made.

fordraiders
0
 
Brendt HessSenior DBACommented:
Whoops! Datagrid (off MS Chart object), *NOT* DBGrid!   Bad Brendt, BAD Brendt! :)

I'll take a look, though.  Be back with any ideas...
0
 
FordraidersAuthor Commented:
bhess1,
I put a simple sendkeys "{right}"
In the got focus event.
This works o.k. for the first Tab around the form.
When it cycles back the cursor advances to the second cell.

This leads me to believe that after I use the right arrow the first time and then cycle back around the form THEN THE DATAGRID OBTAINS FOCUS WITHOUT CODE.  "Yes" This is what happens.

So when I use code the Datagrid on the second cycle Tabing ,  gives Focus to the second cell because it is already advancing to the first cell automatically.
????????
Hope this makes sense.!

fordraiders


0
 
FordraidersAuthor Commented:
Tim,
Works o.k.
How about Datagrid1 AND Datagrid3 Where a new record ISNOT allowed?
Thanks for looking at this question!!!
fordraiders



0
 
FordraidersAuthor Commented:
Tim,
This does not work when adding a new record.?
fordraiders
0
 
FordraidersAuthor Commented:
Comment accepted as answer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.