Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
13 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
Ready to get started with anonymous questions today? It's easy! Learn more.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Here are a few simple, working, games that you can use as-is or as the basis for your own games.
Tic-Tac-Toe
This is one of the simplest of all games.
Â
The game allows for a choice of who goes first and keeps track of the number of wins for…
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…
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…
Suggested Courses
Course of the Month13 days, 13 hours left to enroll
801 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.