controlling automatic printing of two-page report

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top