I have vb form that accepts input from user,search in database(database acess) and displays matching records if any in the listview .The problem is that the search query will display only one matching record even if there are many matching records
.anyone please help
ponnu
0
Light Poster
Recommended Answers
Jump to PostMake use of a loop...
Dim xRecords As Integer rs.MoveFirst 'change rs to whatever you have named your recordset selector For xRecords = 1 To rs.RecordCount ''Do with this record returned what you need to... rs.MoveNext Next xRecords
Jump to Postuse loop after search query
While rec.EOF = False 'write here what you wants (display records) rec.MoveNext wend
hope this helps you
Jump to Postwhat code did you use to perform the desired task . . . . ?
Jump to PostYour problem is the rs(x) part. You can loop through records but not through fields...
Well you can, but that is a totally different issue which is quite complex. :)
What you need to do is to change your code to -
Dim li1 As ListItem ''Dim …
All 13 Replies
AndreRet
526
Senior Poster
rishif2
57
Posting Whiz in Training
ponnu
0
Light Poster
rishif2
57
Posting Whiz in Training
ponnu
0
Light Poster
ponnu
0
Light Poster
ponnu
0
Light Poster
AndreRet
526
Senior Poster
ponnu
0
Light Poster
AndreRet
526
Senior Poster
ponnu
0
Light Poster
AndreRet
526
Senior Poster
hannah_2
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.