 |  |  |  |  |  |  |  |
Code for Find First ...
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Hi, friends!
Could somebody tell me what code should be written for the following buttons to search the database ( I am using ADODC CONTROL) :
Find First
Find Previous
Find Next
Find Last
I will be grateful for any response...
Could somebody tell me what code should be written for the following buttons to search the database ( I am using ADODC CONTROL) :
Find First
Find Previous
Find Next
Find Last
I will be grateful for any response...
Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.open {Connection String}
rs.Open "Select * FROM TABLE;", Conn, 3, 3, 1
use only one of tehse under each correct button
rs.MoveFirst
rs.MovePrevious
rs.MoveNext
rs.MoveLast
Dim rs As ADODB.Recordset
Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.open {Connection String}
rs.Open "Select * FROM TABLE;", Conn, 3, 3, 1
use only one of tehse under each correct button
rs.MoveFirst
rs.MovePrevious
rs.MoveNext
rs.MoveLast
.: We may acquire liberty, but it is never recovered if it is lost :.
irc://irc.rizon.net/#itf
irc://irc.rizon.net/#itf
•
•
•
•
Originally Posted by jwshepherd
Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.open {Connection String}
rs.Open "Select * FROM TABLE;", Conn, 3, 3, 1
use only one of tehse under each correct button
rs.MoveFirst
rs.MovePrevious
rs.MoveNext
rs.MoveLast
Dear Sir,
Thanks for your kind reply. Could you please do me a another favour. Since I dont know where this code goes so I am sending this program in a zip format please modify it and send it back. Sorry to give you trouble.
Have a nice day.
•
•
•
•
Originally Posted by jwshepherd
Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.open {Connection String}
rs.Open "Select * FROM TABLE;", Conn, 3, 3, 1
use only one of tehse under each correct button
rs.MoveFirst
rs.MovePrevious
rs.MoveNext
rs.MoveLast
Could you please re-write the code for me since I am a bit confused.
database path is : C:\CONTACTS (THE FOLDER NAME & DATABASE NAME ARE SAME I.E. CONTACTS)
table name is : CUSTOMERS
Thanks for any help.
|
Similar Threads
- Search code in a database (Visual Basic 4 / 5 / 6)
- Using VB Code - Silent download pdf from server and print to local printer (Visual Basic 4 / 5 / 6)
- Can we Programaticall Write code in VB6.0, forms/standard module/class code window (Visual Basic 4 / 5 / 6)
- need code stuff (Geeks' Lounge)
- Authenticity Code- Same Problem - HELP (Windows 95 / 98 / Me)
- c++ digit code (C++)
- this code isn't working...why..plz help (C++)
- RE: Leaked Windows Source Code (IT Professionals' Lounge)
- Windows 98 authenticity code (Windows 95 / 98 / Me)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Print Screen
- Next Thread: Auto Calculation
Views: 3499 | Replies: 3
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 2007 access activex add age append application basic beginner birth bmp c++ 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 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 struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
