For i = 1 To rs.RecordCount lstShop.ListItems.Add i, , rs.Fields("shop").Value lstShop.ListItems.Item(i).Checked = rs.Fields("active").Value rs.MoveNext Next
For i = 1 To rs.RecordCount lstShop.ListItems.Add i, , rs.Fields("shop").Value rs.MoveNext Next
Public Sub Search(sql As String) Dim rssearch As New ADODB.Recordset Set rssearch = New ADODB.Recordset Dim fld As Field Dim ritem As ListItem Dim nFieldCount As Integer rssearch.Open sql, conn, adOpenDynamic, adLockBatchOptimistic With rssearch ListView1.ListItems.Clear While (Not .EOF) Set ritem = ListView1.ListItems.Add(, , CStr(.Fields(0))) For nFieldCount = 1 To .Fields.Count - 1 ritem.SubItems(nFieldCount) = .Fields(nFieldCount) Next nFieldCount .MoveNext Wend End With Set ritem = Nothing End Sub
lstShop.ListItems.Add i, , rs.Fields("shop").Value
lstShop.ListItems.Item(i).Checked = rs.Fields("active").Value
rs.MoveNext
Next
lstShop.ListItems.Add i, , rs.Fields("shop").Value
rs.MoveNext
Next
Dim rssearch As New ADODB.Recordset
Set rssearch = New ADODB.Recordset
Dim fld As Field
Dim ritem As ListItem
Dim nFieldCount As Integer
rssearch.Open sql, conn, adOpenDynamic, adLockBatchOptimistic
With rssearch
ListView1.ListItems.Clear
While (Not .EOF)
Set ritem = ListView1.ListItems.Add(, , CStr(.Fields(0)))
For nFieldCount = 1 To .Fields.Count - 1
ritem.SubItems(nFieldCount) = .Fields(nFieldCount)
Next nFieldCount
.MoveNext
Wend
End With
Set ritem = Nothing
End Sub