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 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 …
Jump to PostDid you change FieldName1 to your own field name i.e. Id or name etc... ?
Jump to PostWhat error message are you getting?
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.