Packing list Report help - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Packing list Report help

Mark Budinger

4 years ago

I am creating a packing list report for my company. I have two reports created, one is the main (our copy) and the other is the customers copy (same report one just says Customer copy).  Is there a way to combine both of these reports together? That way I can create a command button to preview the report to make sure everything is in order before printing?

I tried

DoCmd.OpenReport "QC_Hillock_Packing_List_Summary", acViewPreview
    DoCmd.OpenReport "QC_Hillock_Packing_List_SummaryCopy2", acViewPreview

This just previews both and I have to click print one both.

I also tried

DoCmd.OpenReport "QC_Hillock_Packing_List_Summary", acViewPreview
    DoCmd.PrintOut , , , , 1
    DoCmd.OpenReport "QC_Hillock_Packing_List_SummaryCopy2", acViewPreview
    DoCmd.PrintOut , , , , 1

then I realized that once I press the button both reports print out then show me the summary.  I know there has to be an easier way to do this that I am just not seeing.

Regards,
Mark

Adam Schwanz @Reply

4 years ago

You could put an onclose event on the second report.

If Msgbox("Would you like to print the two reports?",vbyesnocancel)<>vbyes then
Exit Sub
Else
    DoCmd.OpenReport "QC_Hillock_Packing_List_Summary", acViewPreview
    DoCmd.PrintOut , , , , 1
    DoCmd.Close acReport, "QC_Hillock_Packing_List_Summary"
    DoCmd.OpenReport "QC_Hillock_Packing_List_SummaryCopy2", acViewPreview
    DoCmd.PrintOut , , , , 1
    DoCmd.Close acReport, "QC_Hillock_Packing_List_SummaryCopy2"
End If

	Adam Schwanz @Reply 4 years ago
I don't think by default you can press the print button once (in print preview) and have it print two reports though. Other options would be to combine both reports into one report or there are a few other spots you could put the code.

	Mark Budinger OP @Reply 4 years ago
Hi Adam, I would actually like to combine both reports in one report. I can't seem to figure out how to properly do that.

	Adam Schwanz @Reply 4 years ago
Just drag and drop the second report onto the first report, it will become a subreport. Adjust size/settings as needed.

	Adam Schwanz @Reply 4 years ago
Or Use the Grouping and Sorting, Add a second field to group by, turn on "with footer", then put the subform in there on the footer, can use force new page then if you cant get the measurements to line up.

	Kevin Yip @Reply 4 years ago
Hi Mark, one way to combine multiple reports is to print each one out to a PDF file, then use a third-party tool like PDFtk (which is free: https://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/ ) to combine them. This tool can be run at the command line, which means you can automate the process by having Access run a command line, with the Shell() function.

	Mark Budinger OP @Reply 4 years ago
Kevin, Thank you for this tip. I just might give this a try. Regards, Mark

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View