?
Solved

Creating a two page report in Access

Posted on 2012-08-20
8
Medium Priority
?
838 Views
Last Modified: 2012-08-21
I would like to create a two page report in MS-Access with the second page being printed on the reverse side of the page (i know this also has to do with the printer settings, i.e., duplex printing). Where and how do I create the second page of the report?
0
Comment
Question by:geeta_m9
  • 4
  • 4
8 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38313373
In the most basic sense, this is controlled by the Printer.
If your printer is configured as "Full Duplex", then if your data spans two pages, second page will be on the reverse side of Page 1

Are you saying that your printer is configured for full duplex (double sided Printing)... and it is NOT printing on both sides of the paper?
0
 

Author Comment

by:geeta_m9
ID: 38313380
My printer is configured for duplex, however, I do not know where the first page ends and the second page begins in the report.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 2000 total points
ID: 38313416
Check your Printer settings for the Report:

Open the report in Design View
(Make a small change to the design of the report ...ex: Move a control slightly)
Click the "Page setup" tab
Click the "Page setup" Icon
Click the "page" Tab
Select: "Use Specific Printer"
Select your Printer
Select Properties, ...and make sure "full Duplex" or "double Sided" printing is selected.
Save the Report.
Close the Report.
Compact and repair the database.
Try printing the report again.

JeffCoachman
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 38313431
<My printer is configured for duplex, however, I do not know where the first page ends and the second page begins in the report. >

Open the report in "Print Preview" explicitly and you will see actually where the page breaks.

The Default view for reports in Access 2007 and newer is "Report  View"
This view does not display the page breaks.

If you open the Report in Print Preview, explicitly, you will see the breaks.

JeffCoachman
0
 

Author Comment

by:geeta_m9
ID: 38313439
So, would I have to do it by trial and error to determine where the new page starts. Doesn't Access have a way of delineating the pages?
0
 

Author Comment

by:geeta_m9
ID: 38313442
Ok, your last response crossed with my latest comment. Let me try what you suggested.
0
 

Author Closing Comment

by:geeta_m9
ID: 38313918
Thanks!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38318730
;-)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question