My setup is VB6/Access2K. I have a DataGrid1 connected via ADODC1 to the Access2K Table. On the VB Form, I have the DataGrid1 and ADODC1 along with a Command Button.
When the Command Button is clicked, I would like each Record from the Access Table to print out on a VB DataReport I created, but I would like each Record to start on a new page of the DataReport.
My code for the Command Button for printing the DataReport is:
Private Sub Command10_Click(Index As Integer)
OpenReport1
End Sub
Private Sub OpenReport1()
Dim rpt As NewDepReport
Set rpt = New NewDepReport
rpt.Display Me.Adodc1.Recordset, vbModal
Set rpt = Nothing
End Sub
This code prints all of the Records just fine, but they're run together. Can someone tell me what I need to do to the code to make each Record start on a new page?
Thanks in advance!!
When the Command Button is clicked, I would like each Record from the Access Table to print out on a VB DataReport I created, but I would like each Record to start on a new page of the DataReport.
My code for the Command Button for printing the DataReport is:
Private Sub Command10_Click(Index As Integer)
OpenReport1
End Sub
Private Sub OpenReport1()
Dim rpt As NewDepReport
Set rpt = New NewDepReport
rpt.Display Me.Adodc1.Recordset, vbModal
Set rpt = Nothing
End Sub
This code prints all of the Records just fine, but they're run together. Can someone tell me what I need to do to the code to make each Record start on a new page?
Thanks in advance!!