 |  |  |  |  |  |  |  |
Help me Please about adodc1
 |
i have adodc1 i want to assign pressing f1 is the first data and f2 in next and f3 is previous and f4 is last data can anyone help me? please help me i need it!
•
•
Join Date: Apr 2008
Posts: 53
Reputation: 
Solved Threads: 2
Junior Poster in Training
Use Key ASCii Value of That Keys.
Set a Condidtion,"if <Key ASCii>=<Key Code> then ACTION Else ACTION"
Set a Condidtion,"if <Key ASCii>=<Key Code> then ACTION Else ACTION"
If Shift And vbCtrlMask And KeyCode = vbKeyE Then
If cmdEdit.Enabled = True Then
I think you want to asign a shortcut key , if so, IN VB, you can write this code in the Form Keydown event, like this:
If Shift And vbCtrlMask And KeyCode = vbKeyF1 Then
adodc1.MoveFirst
ElseIf Shift And vbCtrlMask And KeyCode = vbKeyF2 Then
adodc1.MoveNext
ElseIf Shift And vbCtrlMask And KeyCode = vbKeyF3 Then
adodc1.MovePrevious
ElseIf Shift And vbCtrlMask And KeyCode = vbKeyF4 Then
adodc1.MoveLast
end if
Different KeyBoard Key can assign to Diff shortcut for your form.
I Think this will be helpful to you.
If cmdEdit.Enabled = True Then
I think you want to asign a shortcut key , if so, IN VB, you can write this code in the Form Keydown event, like this:
If Shift And vbCtrlMask And KeyCode = vbKeyF1 Then
adodc1.MoveFirst
ElseIf Shift And vbCtrlMask And KeyCode = vbKeyF2 Then
adodc1.MoveNext
ElseIf Shift And vbCtrlMask And KeyCode = vbKeyF3 Then
adodc1.MovePrevious
ElseIf Shift And vbCtrlMask And KeyCode = vbKeyF4 Then
adodc1.MoveLast
end if
Different KeyBoard Key can assign to Diff shortcut for your form.
I Think this will be helpful to you.
|
Similar Threads
- Search code in a database (Visual Basic 4 / 5 / 6)
- Searching for records contained in access from VB (Visual Basic 4 / 5 / 6)
- ADO Data Control (ADODC) Problems with .recordset.find (Visual Basic 4 / 5 / 6)
- Integer to string then 2 listbox (Visual Basic 4 / 5 / 6)
- Need Urgent Solution (Visual Basic 4 / 5 / 6)
- add record in table with button and textbox (Visual Basic 4 / 5 / 6)
- Access and VB (Visual Basic 4 / 5 / 6)
- Text box population from DBgrid. HELP!! (Visual Basic 4 / 5 / 6)
- VB6 and MS Access 2002 (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Help creating specific macro
- Next Thread: Word 2007 - Reference Images Within Document
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
