We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Solved
sendkey question (or other options)
Posted on 2002-06-24
i have a program that requires that the arrow keys be converted to act as tab keys moving back and forth between objects on my form.
here is some code that i picked up from msdn, but does not seem to work when moving outside of the frame with focus (moving from object to object within the fram works fine).
If Screen.ActiveControl.TabIn
NextTabIndex = 0
Else
NextTabIndex = Screen.ActiveControl.TabIn
End If
For i = 0 To Count - 1
If Me.Controls(i).TabIndex = NextTabIndex Then
Me.Controls(i).SetFocus
Exit For
End If
Next i
i have also attempted to use the sendkey function, but this for some reason has been causing the num lock key to turn off without reason (irregularly).
Call SendKeys("{TAB}") or Call SendKeys("+{TAB}")
if anyone knows of a good work around that will keep my num lock key from turning off or can provide code that will allow me to check at the end of my function if the numlock key is off and to turn it back on if it did accidentally get shut off the points will be awarded to you. thanks.
here is some code that i picked up from msdn, but does not seem to work when moving outside of the frame with focus (moving from object to object within the fram works fine).
If Screen.ActiveControl.TabIn
NextTabIndex = 0
Else
NextTabIndex = Screen.ActiveControl.TabIn
End If
For i = 0 To Count - 1
If Me.Controls(i).TabIndex = NextTabIndex Then
Me.Controls(i).SetFocus
Exit For
End If
Next i
i have also attempted to use the sendkey function, but this for some reason has been causing the num lock key to turn off without reason (irregularly).
Call SendKeys("{TAB}") or Call SendKeys("+{TAB}")
if anyone knows of a good work around that will keep my num lock key from turning off or can provide code that will allow me to check at the end of my function if the numlock key is off and to turn it back on if it did accidentally get shut off the points will be awarded to you. thanks.
[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
-
3
-
3
- +1
8 Comments
instead of using sendkeys...
Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Private Const VK_TAB = &H9
public sub command1_click
keybd_event VK_TAB, 0, 0, 0
end sub
Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Private Const VK_TAB = &H9
public sub command1_click
keybd_event VK_TAB, 0, 0, 0
end sub
Hi Hotwu,
When you say that the sendkey function Lock the Keyboard.
Your vbapp is running in WinNT o Win2k?
I using this way:
Private Sub txt_fields_KeyPress(Index As Integer, KeyAscii As Integer)
If KeyAscii = 13 Then
SendKeys "{TAB}", True
KeyAscii = 0
end if
end sub
You have to use the True for the [wait] option.
When you say that the sendkey function Lock the Keyboard.
Your vbapp is running in WinNT o Win2k?
I using this way:
Private Sub txt_fields_KeyPress(Index As Integer, KeyAscii As Integer)
If KeyAscii = 13 Then
SendKeys "{TAB}", True
KeyAscii = 0
end if
end sub
You have to use the True for the [wait] option.
Private Sub PressTab()
keybd_event VK_TAB, 0, 0, 0
End Sub
Private Sub PressBackTab()
'' press and hold shift
keybd_event VK_SHIFT, 0, 0, 0
'' press tab
keybd_event VK_TAB, 0, 0, 0
'' release shift
keybd_event VK_SHIFT, 0, KEYEVENTF_KEYUP, 0
End Sub
keybd_event VK_TAB, 0, 0, 0
End Sub
Private Sub PressBackTab()
'' press and hold shift
keybd_event VK_SHIFT, 0, 0, 0
'' press tab
keybd_event VK_TAB, 0, 0, 0
'' release shift
keybd_event VK_SHIFT, 0, KEYEVENTF_KEYUP, 0
End Sub
bobbit31 ~ so very close... exactly what i am looking for, however i am having problems with the backtab... i think that the shift key press is not in a holding state. almost as though you press it then it let's go. not sure, but the backtab function also moves me forwards just like the tab function.
hrmm, make sure you have the constants correct
Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Private Const VK_TAB = &H9
Private Const VK_SHIFT = &H10
Private Const KEYEVENTF_KEYUP = &H2
Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Private Const VK_TAB = &H9
Private Const VK_SHIFT = &H10
Private Const KEYEVENTF_KEYUP = &H2
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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…
Introduction
While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC. I didn't post completely correct code o…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.
This l…
- Microsoft Office
- Office 365
- Microsoft Access
- VBA
- Microsoft Excel
- Visual Basic Classic
Suggested Courses
Course of the Month10 days, 6 hours left to enroll
618 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.