For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Course Of The Month
1 day, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
TAB key with DataGrid Control
Posted on 2000-04-28
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
9
3
13 Comments
Active 1 day ago
Recommendation: When the .Gotfocus event fires on your grid, set highlighting on the current row. Your cursor will be visible then.
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
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
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
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
Active 1 day ago
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)
bHess1,
I have had success(but not complete) so far with the following:
Private Sub DataGrid2_GotFocus()
IF (DATAGRID1.SELBOOKMARKS.CO
DATAGRID2.SELBOOKMARKS.REM
END IF
IF ADODC3.RECORDSET.RECORDCOU
AND DATAGRID2.ROW = 0 THEN
IF ADODC3.RECORDSET.RECORDCOU
AND DATAGRID2.ROW = -1 THEN
Datagrid2.selBookmarks.add
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
I have had success(but not complete) so far with the following:
Private Sub DataGrid2_GotFocus()
IF (DATAGRID1.SELBOOKMARKS.CO
DATAGRID2.SELBOOKMARKS.REM
END IF
IF ADODC3.RECORDSET.RECORDCOU
AND DATAGRID2.ROW = 0 THEN
IF ADODC3.RECORDSET.RECORDCOU
AND DATAGRID2.ROW = -1 THEN
Datagrid2.selBookmarks.add
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
Active 1 day ago
Whoops! Datagrid (off MS Chart object), *NOT* DBGrid! Bad Brendt, BAD Brendt! :)
I'll take a look, though. Be back with any ideas...
I'll take a look, though. Be back with any ideas...
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
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
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.
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.
Tim,
Works o.k.
How about Datagrid1 AND Datagrid3 Where a new record ISNOT allowed?
Thanks for looking at this question!!!
fordraiders
Works o.k.
How about Datagrid1 AND Datagrid3 Where a new record ISNOT allowed?
Thanks for looking at this question!!!
fordraiders
Featured Post
Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month1 day, 23 hours left to enroll
Earn Certification
CompTIA IT Fundamentals
$49.00$44.10
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.