popodc
May 1st, 2006, 07:49 PM
Set rsDis = New ADODB.Recordset
sql = "select chkname, chkdate, chktotal, chknumtoword from checktable"
rsDis.Open sql, cn
Set DataReport1.DataSource = rsDis
DataReport1.Sections(1).Controls("lblAccount").Caption = rsDis(0)
DataReport1.Sections(1).Controls("lblDate").Caption = rsDis(1)
DataReport1.Sections(1).Controls("lblTotal").Caption = rsDis(2)
DataReport1.Sections(1).Controls("lblNum2Wrd").Caption = rsDis(3)
DataReport1.Show
i want the next row of my recordset in the next page of the datareport. how? i am using vb 6. thanks!
sql = "select chkname, chkdate, chktotal, chknumtoword from checktable"
rsDis.Open sql, cn
Set DataReport1.DataSource = rsDis
DataReport1.Sections(1).Controls("lblAccount").Caption = rsDis(0)
DataReport1.Sections(1).Controls("lblDate").Caption = rsDis(1)
DataReport1.Sections(1).Controls("lblTotal").Caption = rsDis(2)
DataReport1.Sections(1).Controls("lblNum2Wrd").Caption = rsDis(3)
DataReport1.Show
i want the next row of my recordset in the next page of the datareport. how? i am using vb 6. thanks!