Hi guys
I am getting a problem in the loop below. It doesn't display me each person's record. Can anyone please solve my problem.
Thanks![]()
Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim r As Long ' connect to the Access database Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=c:\abc.mdb;" ' open a recordset Set rs = New ADODB.Recordset strsql = "Select Username,count(*) as 'Total Letters',max(Time1),min(time1) from tblmaster where Date1=# " & Format(DateSerial(ComboBox3, ComboBox2, ComboBox1), "mm/dd/yyyy") & " # group by Username" rs.Open strsql, cn J = ActiveSheet.UsedRange.Rows.Count ws.Cells(J + 5, 1).Value = "Username" ws.Cells(J + 5, 2).Value = "Total Letters" Do While Not rs.EOF dtmLower = rs.Fields(3) dtmupper = rs.Fields(2) dtmtotal = dtmupper - dtmLower ws.Cells(J + 6, 1).Value = rs.Fields(0) ws.Cells(J + 6, 2).Value = rs.Fields(1) ws.Cells(J + 6, 3).Value = dtmtotal rs.MoveNext J = ActiveSheet.UsedRange.Rows.Count Loop
Aman











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks