Nov 2, 2004 #1 scra Technical User Dec 7, 2001 55 US What is the code to print 2 or more copies of a report? I have a print command button and needs to print multiple copies of a single report.
What is the code to print 2 or more copies of a report? I have a print command button and needs to print multiple copies of a single report.
Nov 2, 2004 #2 hymn Technical User Feb 27, 2003 1,036 GB Might help http://support.microsoft.com/?kbid=209006 Hope this helps Hymn Upvote 0 Downvote
Nov 2, 2004 #3 hymn Technical User Feb 27, 2003 1,036 GB Might help http://support.microsoft.com/?kbid=209006 Hope this helps Hymn Upvote 0 Downvote
Nov 2, 2004 Thread starter #4 scra Technical User Dec 7, 2001 55 US Thanks, but this is not what I'm looking for. I need to print more than 1 copy of a report not records. Upvote 0 Downvote
Thanks, but this is not what I'm looking for. I need to print more than 1 copy of a report not records.
Nov 2, 2004 #5 hymn Technical User Feb 27, 2003 1,036 GB -+Sorry wrong one http://www.mvps.org/access/reports/rpt0001.htm Hope this helps Hymn Upvote 0 Downvote
Nov 3, 2004 Thread starter #6 scra Technical User Dec 7, 2001 55 US Thanks for the code. I have attempted to place the code(s) and no luck. Any ideas as to where? Private Sub cmd_Print_Location1_Click() On Error GoTo Err_cmd_Print_Location1_Click Dim stDocName As String If chk01 = -1 Then DoCmd.OpenReport "Rpt: Contract SW" Exit_cmd_Print_Location1_Click: Exit Sub Err_cmd_Print_Location1_Click: MsgBox Err.Description Resume Exit_cmd_Print_Location1_Click End Sub Upvote 0 Downvote
Thanks for the code. I have attempted to place the code(s) and no luck. Any ideas as to where? Private Sub cmd_Print_Location1_Click() On Error GoTo Err_cmd_Print_Location1_Click Dim stDocName As String If chk01 = -1 Then DoCmd.OpenReport "Rpt: Contract SW" Exit_cmd_Print_Location1_Click: Exit Sub Err_cmd_Print_Location1_Click: MsgBox Err.Description Resume Exit_cmd_Print_Location1_Click End Sub
Nov 3, 2004 #7 hymn Technical User Feb 27, 2003 1,036 GB Tried and tested on A2002 DoCmd.OpenReport "Birthdays", acViewPreview DoCmd.PrintOut , , , , 2 Hope this helps Hymn Upvote 0 Downvote
Tried and tested on A2002 DoCmd.OpenReport "Birthdays", acViewPreview DoCmd.PrintOut , , , , 2 Hope this helps Hymn