Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access database form printing problem.

Posted on 2016-08-11
6
Medium Priority
?
115 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
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 31

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 40

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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 1

Author Comment

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

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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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.
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

581 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