Preview Report Then Print 4 Copies (1 Viewer)

access2010

Registered User.
Joined
Dec 26, 2009
Messages
1,027
Could I please get a code suggestion to preview a report and then print 4 copies using the Macro = Control + E.

Your suggestions are appreciated.

Nicole
 

Attachments

What have you attempted so far? What results did you get? What problems did you encounter?
 
Thank you GP George for your question.

The currently Macro previews the document and then 2 copies are printed, while we would like the Macro to preview the document and than print 4 copies..

Nicole
 
Could I please get a code suggestion to preview a report and then print 4 copies using the Macro = Control + E.

Your suggestions are appreciated.

Nicole
Hi Nicole
It would help if we had an actual Report to Print.
 
Please open the database and use Ctrl + E to open up the report, that we would use or look at the report => Print_4_Pages.

The actual detailed report will be used for data entry after printing and we prefer not to use a Wor
Thank you GP George for your question.

The currently Macro previews the document and then 2 copies are printed, while we would like the Macro to preview the document and than print 4 copies..

Nicole
Please open the database and use Ctrl + E to open up the report, that we would use or look at the report => Print_4_Pages.

The actual detailed report is used for data entry after printing and we prefer not to use a Word Document.

Thank you.
Nicole
 
Please open the database and use Ctrl + E to open up the report, that we would use or look at the report => Print_4_Pages.

The actual detailed report will be used for data entry after printing and we prefer not to use a Wor

Please open the database and use Ctrl + E to open up the report, that we would use or look at the report => Print_4_Pages.

The actual detailed report is used for data entry after printing and we prefer not to use a Word Document.

Thank you.
Nicole
Hi Nicole
The Report "Print_4_Pages" does not have a Record Source

What are you expecting to Print?
 
The BLANK TEMPLATE is used for the user’s research and is then completed MANUALLY. The updated research report data is then entered into the volunteer's database.
Once we have help with the code, I will create more templates for our other research projects. We do not want to use a Word Template.

Thank you very much.
Nicole
 
There is no code to review.

There is a PrintObject macro command but doesn't seem to have argument for number of copies. I don't use macros.

VBA DoCmd.PrintOut has an argument for number of copies.

DoCmd.OpenReport ...
DoCmd.PrintOut ...
DoCmd.Close ...

Now when you have some code with issue, post it for review.
 
Last edited:
you need to add a RecordSource to the Report.
Create a dummy table (dummyT on the demo), then add as many records you want.
Adjust the Height of the report to conform to the size of the paper you want to print.
You only need 4 pages, so to do that, add a Query to the Report's Recordsource:

Code:
SELECT TOP 4 dummyT.* FROM dummyT;

now if there are extra pages being print, adjust the height of the detail section (make it shorter).
 

Attachments

A report does not require a recordsource in order to print. Although, in this case, it might be the means to get desired output. Since OP has not completed report design, hard to say.
 
you need to add a RecordSource to the Report.
Create a dummy table (dummyT on the demo), then add as many records you want.
Adjust the Height of the report to conform to the size of the paper you want to print.
You only need 4 pages, so to do that, add a Query to the Report's Recordsource:

Code:
SELECT TOP 4 dummyT.* FROM dummyT;

now if there are extra pages being print, adjust the height of the detail section (make it shorter).
Thank you for sending us your database, but we cannot open it because of the "Unrecognized Database Format" message. Could you please send us another database. Thank you very much
 
sorry, i edited the report in MSA 2021.
here is an A2003 version.
 

Attachments

Users who are viewing this thread

Top Bottom