K
Kyle
In my database, I've had to create a two-page report that is meant to
print double-sided on one sheet of paper. When printing out this report
for all records, the office is careful to use a duplexing printer.
But I have set up a command button on my input form that allows me to
print out a single copy of the report for a specific record in the
database. I used the following VB:
Private Sub Print_Update_Form_Click()
On Error GoTo Err_Print_Update_Form_Click
Dim stDocName As String
Dim strRecID As String
strRecID = "[C-CUREEventID]='" & Me![C-CUREEventID] & "'"
stDocName = "Update Forms for PIs"
DoCmd.OpenReport stDocName, acPreview, , strRecID
Exit_Print_Update_Form_Click:
Exit Sub
Err_Print_Update_Form_Click:
MsgBox Err.Description
Resume Exit_Print_Update_Form_Click
End Sub
If I add the line "DoCmd.PrintOut acPages..." after the
"DoCmd.OpenReport..." line, then it will print out both pages on two
separate sheets of paper. First question: is there a way of
automatically detecting from within Access if a user is connected to a
duplexing printer (I know - lots to ask)?
Second question: is there a command I could insert that would
automatically print the first page and then prompt the user to print
page two (give 'em time to flip the page and put it in the manual feed
of the printer)?
Alternately, can anyone suggest a simple approach to having this button
work for both users with duplexing printers and users with "simplexing"
printers?
print double-sided on one sheet of paper. When printing out this report
for all records, the office is careful to use a duplexing printer.
But I have set up a command button on my input form that allows me to
print out a single copy of the report for a specific record in the
database. I used the following VB:
Private Sub Print_Update_Form_Click()
On Error GoTo Err_Print_Update_Form_Click
Dim stDocName As String
Dim strRecID As String
strRecID = "[C-CUREEventID]='" & Me![C-CUREEventID] & "'"
stDocName = "Update Forms for PIs"
DoCmd.OpenReport stDocName, acPreview, , strRecID
Exit_Print_Update_Form_Click:
Exit Sub
Err_Print_Update_Form_Click:
MsgBox Err.Description
Resume Exit_Print_Update_Form_Click
End Sub
If I add the line "DoCmd.PrintOut acPages..." after the
"DoCmd.OpenReport..." line, then it will print out both pages on two
separate sheets of paper. First question: is there a way of
automatically detecting from within Access if a user is connected to a
duplexing printer (I know - lots to ask)?
Second question: is there a command I could insert that would
automatically print the first page and then prompt the user to print
page two (give 'em time to flip the page and put it in the manual feed
of the printer)?
Alternately, can anyone suggest a simple approach to having this button
work for both users with duplexing printers and users with "simplexing"
printers?