bneuman
asked on
Multiple form printing
I have the following code thats works well. I can print out forms within a certain date range. Under one button I print out five different forms at once (only if they contain data). My problem is that if the first form of the five does not contain data the other 4 reports won't print. Even if they contain data. Can someone tell me how to correct this? Heres the code: (under case 4)
Sub PrintReports(PrintMode As Integer)
On Error GoTo Err_Preview_Click
' This procedure used in Preview_Click and Print_Click Sub procedures.
' Preview or print report selected in the ReportToPrint option group.
' Then close the Print Sales Reports Dialog form.
Dim strWhereCategory As String
If Me![optBeginDt] = "" Or Me![optEndDt] = "" Then
Beep
MsgBox "Please enter a valid start date", vbInformation, "Date Error"
Me![optBeginDt].SetFocus
Else
strWhereCategory = "date between Forms![Daily Reports]!optBeginDt and Forms![Daily Reports]!optEndDt"
Select Case Me![ReportToPrint]
Case 1
DoCmd.OpenReport "Oxygen Report1", PrintMode, , strWhereCategory
Case 2
DoCmd.OpenReport "Roast Colors Report", PrintMode, , strWhereCategory
Case 3
DoCmd.OpenReport "Bulk Report", PrintMode, , "[Date Rec'd] between Forms![Daily Reports]!optBeginDt and Forms![Daily Reports]!optEndDt"
Case 4
DoCmd.OpenReport "GrindA1 Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "GrindA1U Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "GrindA2 Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "GrindA3 Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "GrindA4 Report", PrintMode, , strWhereCategory
Case 5
DoCmd.OpenReport "Difference Report", PrintMode, , strWhereCategory
Case 6
DoCmd.OpenReport "Roasted Bulk/Moisture Report", PrintMode, , strWhereCategory
Case 7
DoCmd.OpenReport "Oxygen Report1", PrintMode, , strWhereCategory
DoCmd.OpenReport "Roast Colors Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "Bulk Report", PrintMode, , "[Date Rec'd] between Forms![Daily Reports]!optBeginDt and Forms![Daily Reports]!optEndDt"
DoCmd.OpenReport "Grind Analysis Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "Difference Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "Roasted Bulk/Moisture Report", PrintMode, , strWhereCategory
End Select
DoCmd.Close acForm, "Daily Reports"
End If
Sub PrintReports(PrintMode As Integer)
On Error GoTo Err_Preview_Click
' This procedure used in Preview_Click and Print_Click Sub procedures.
' Preview or print report selected in the ReportToPrint option group.
' Then close the Print Sales Reports Dialog form.
Dim strWhereCategory As String
If Me![optBeginDt] = "" Or Me![optEndDt] = "" Then
Beep
MsgBox "Please enter a valid start date", vbInformation, "Date Error"
Me![optBeginDt].SetFocus
Else
strWhereCategory = "date between Forms![Daily Reports]!optBeginDt and Forms![Daily Reports]!optEndDt"
Select Case Me![ReportToPrint]
Case 1
DoCmd.OpenReport "Oxygen Report1", PrintMode, , strWhereCategory
Case 2
DoCmd.OpenReport "Roast Colors Report", PrintMode, , strWhereCategory
Case 3
DoCmd.OpenReport "Bulk Report", PrintMode, , "[Date Rec'd] between Forms![Daily Reports]!optBeginDt and Forms![Daily Reports]!optEndDt"
Case 4
DoCmd.OpenReport "GrindA1 Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "GrindA1U Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "GrindA2 Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "GrindA3 Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "GrindA4 Report", PrintMode, , strWhereCategory
Case 5
DoCmd.OpenReport "Difference Report", PrintMode, , strWhereCategory
Case 6
DoCmd.OpenReport "Roasted Bulk/Moisture Report", PrintMode, , strWhereCategory
Case 7
DoCmd.OpenReport "Oxygen Report1", PrintMode, , strWhereCategory
DoCmd.OpenReport "Roast Colors Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "Bulk Report", PrintMode, , "[Date Rec'd] between Forms![Daily Reports]!optBeginDt and Forms![Daily Reports]!optEndDt"
DoCmd.OpenReport "Grind Analysis Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "Difference Report", PrintMode, , strWhereCategory
DoCmd.OpenReport "Roasted Bulk/Moisture Report", PrintMode, , strWhereCategory
End Select
DoCmd.Close acForm, "Daily Reports"
End If
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bill