hi. I am working on a project that requires a search button. it goes like this. the I will enter data on a text box. then the record that goes with it will display on the 3 textboxes. My problem is I don't know how to code a search buttons. please help.
problematic:)
0
Light Poster
Recommended Answers
Jump to PostWhat kind of database are you using, access, MySql etc?
Jump to PostCould you give us some sample data on what kind of data you were searching?
-> for example: like typing the Customer ID on a textbox, then perform search and display the customer info. such as last name, first name and middle name on these three texboxes...(Are these is …
Jump to PostYour select statement would be -
SELECT * FROM MyTableName WHERE TheName LIKE " & "'" & "Prob%" & "'"
This will return all names in the database that has prob in itself.
Have a look at the following link -
Jump to PostDo the following -
Option Explicit Private Sub cmdSearch_Click() 'Declare connection and recordset Dim cnSearch As ADODB.Connection Dim rsSearch As ADODB.Recordset 'Create a new instance of connection and recordset Set cnSearch = New ADODB.Connection Set rsSearch = New ADODB.Recordset 'Open connection cnSearch.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\MySearch.MDB;Persist Security Info=False" 'Open …
All 13 Replies
AndreRet
526
Senior Poster
PoisonedHeart
4
Junior Poster in Training
problematic:)
0
Light Poster
AndreRet
526
Senior Poster
problematic:)
0
Light Poster
AndreRet
526
Senior Poster
problematic:)
0
Light Poster
AndreRet
526
Senior Poster
pgalivar11
0
Newbie Poster
jennylynB
0
Newbie Poster
jennylynB
0
Newbie Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
sai.pawar.p
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.