Hi everybody,
I have used the following code to retrieve and display the details from the database table.
For that, I want the codings to take printout of the details what are all contained in the listview contol.So kindly anyone reply me as soon as possible.
I have used the following code to retrieve and display the details from the database table.
Code:
rs3.Open "select * from tbl where empid = '" & Text1.Text & "' AND dat Between #" & Text2.Text & "# AND #" & Text3.Text & "#", con, adOpenForwardOnly, adLockReadOnly rs3.MoveFirst Do Until rs3.EOF j = j + 1 lv.ListItems.Add j, , j lv.ListItems(j).SubItems(1) = rs!empid lv.ListItems(j).SubItems(2) = rs1!firstname & rs1!lastname lv.ListItems(j).SubItems(3) = rs3!dat lv.ListItems(j).SubItems(4) = rs3!intime lv.ListItems(j).SubItems(5) = rs3!outtime rs3.MoveNext Loop
Comment