Solved

Access database form printing problem.

Posted on 2016-08-11
6
83 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 500 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

695 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