hi..i got a problem regarding how could populate data from adodb recordset into textbox...when i type the first letter for example of the itemname then automatically the textbox will show different records from the database starting with the first letter i type until i type the next and so forth...pls help me...i dont have an initial code because i try to research but i cant find one and i cnt undrstand...tnk u...
mitchney
0
Newbie Poster
Recommended Answers
Jump to PostHi, here's my example on how to do that i'm using Data Control and DBGrid, you type something in a Text Box called Text1 and see the result in DBGrid1.
Private Sub Text1_Change() Data1.RecordSource = "Select * from Data where No_Id like'" & Text1.Text & "*'" Data1.Refresh …
Jump to Posti am using the adodb as my recordset..what should i put as my recordsource?
There are different ways to open a recordset.
I usually do the following:Dim cnAdodb as ADODB.Connection Dim rst as ADODB.Recordset Dim strSQL as String set cnAdodb = new ADODB.Connection set rst = …
All 7 Replies
J.B.Alia
0
Newbie Poster
mitchney
0
Newbie Poster
hkdani
39
Posting Pro in Training
mitchney
0
Newbie Poster
hkdani
39
Posting Pro in Training
mitchney
0
Newbie Poster
hkdani
39
Posting Pro in Training
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.