?
Solved

Access database form printing problem.

Posted on 2016-08-11
6
Medium Priority
?
92 Views
Last Modified: 2016-08-21
Got this from a friend.  I've not used Access in years and Google doesn't seem to be giving me the answer:

I'm working on an Access database with a form and subform that feed into a report and subreport. I've put a print button into the form to be able to print the current record, along with the corresponding records in the subform. The problem is that the report prints multiple identical pages - one page for each subrecord, even though they are all listed on every page. I'm trying to get it to just print one page.
0
Comment
Question by:Azra Lyndsey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 25

Expert Comment

by:chaau
ID: 41753384
One of the think to look for is the "Force new page" property for the subreport's detail section
0
 
LVL 30

Expert Comment

by:hnasr
ID: 41753580
Is it printing one main record?

If a subreport is linked to a main report, it should print main record, and then lists all related subrecords as per design. In general, by default, no force of new pages.

If you can, reproduce the issue with a simple demo database.
0
 
LVL 38

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 41753907
When you use a main report/subreport or main form/subform, the main form/report is bound to the parent table or query thereof and the subform/subreport is bound to the child table or query thereof.  Your problem sounds as though the main report's RecordSource includes a join to the table for the subreport and so you are returning a main report record for every subreport record when there should be only one main report record.
1
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 1

Author Comment

by:Azra Lyndsey
ID: 41764700
This did it.  Thank you, all, for your help.
0
 
LVL 38

Expert Comment

by:PatHartman
ID: 41764704
You're welcome.  Please close the thread.
0
 
LVL 1

Author Closing Comment

by:Azra Lyndsey
ID: 41764714
This did it.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

764 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