How do you print a multi-copy report from a form? Please
How do you print a multi-copy report from a form? Please
(OP)
I’m trying to print a multi-copy report from a form. These reports replicate certain multi-copy bureaucratic forms on n-part colored cabonless copy paper.
You select the forms to print with a multi-select list box. After some checking & processing I try to do the following:
Select Case actOpt.Value
Case 1: 'Print
'mark records for printing
For Each docPtr In docList.ItemsSelected
rsDoc.Find "[DocID] = " & CStr(docList.Column(0, docPtr))
rsDoc![Action] = True 'flag for report query
rsDoc.Update 'post changes
rsDoc.MoveFirst 'so next search starts at begining
Next
'print records
On Error GoTo Err_act_Click
'DoCmd.PrintOut , , , acHigh, 2, False <<<<<<<Only prints current screen
DoCmd.OpenReport "CheckReq", acNormal <<<Only prints one page
'deselect records
…
Maybe some out there has tried to do the same thing?
Thanks for any help you can give in advance.
rafe
You select the forms to print with a multi-select list box. After some checking & processing I try to do the following:
Select Case actOpt.Value
Case 1: 'Print
'mark records for printing
For Each docPtr In docList.ItemsSelected
rsDoc.Find "[DocID] = " & CStr(docList.Column(0, docPtr))
rsDoc![Action] = True 'flag for report query
rsDoc.Update 'post changes
rsDoc.MoveFirst 'so next search starts at begining
Next
'print records
On Error GoTo Err_act_Click
'DoCmd.PrintOut , , , acHigh, 2, False <<<<<<<Only prints current screen
DoCmd.OpenReport "CheckReq", acNormal <<<Only prints one page
'deselect records
…
Maybe some out there has tried to do the same thing?
Thanks for any help you can give in advance.
rafe
RE: How do you print a multi-copy report from a form? Please
I am not sure why you are trying to print the form. Printing forms in Access is never a good idea. Forms can be thought of as on-line reports; printed reports should be produced using Report design.
Kathryn
RE: How do you print a multi-copy report from a form? Please
first, thanks for the speedy reply. sorry i wasn't clear
yes the action field change works correctly.
i agree 100% that i should print a report & not a form. which is what i'm trying to do from a form
i'm trying to print an already created report by selecting items on a form. the report was designed 1st and now i'm trying to select which documents to print to by using the some program logic so i'm only showing unprinted documents
in a multi-select list box for the final document selection.
before i was manually clicking on the document table document records' action fields in the table view to select the documents to print on a report. then i've been going to the file/print dialog box to select the needed # of copies of (& w/o collating)
the DoCmd.OpenReport &
DoCmd.PrintOut
don't allow me to print mutiple copies of a report. or do they & i'm not using them correctly?
anyway, i've noticed that your really good at helping people with access. thanks again
rafe
RE: How do you print a multi-copy report from a form? Please
I am out of the office until next Tuesday, so I hope this works! If not, I'll get back to you then.
Kathryn
RE: How do you print a multi-copy report from a form? Please
Kathryn you are correct. the correct sequence should be...
DoCmd.OpenReport "CheckReq", acPreview
DoCmd.PrintOut , , , acHigh, 2, False
DoCmd.Close acReport, "CheckReq"
thanks lots & enjoy your time away from the office
rafe