Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2005

Tip: Looking for answers? Try searching our database.

Printing multiple copies of a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian_G. - 31 Mar 2005 21:49 GMT
Hello.  I'm trying to troubleshoot why a form I designed is printing multiple
copies (an entire report for each record) instead of one when I hit the
<print> button.  So, when I have 70 records in the subform, the report will
print 70 times instead of only once. I have read the other questions and did
not see anything resembling this problem.

The subform is based on a simple query from a table and does not include any
relationships. The property is set to single form view, and the 70 or so
records fill up 5 pages in one printing.

I can temporarily remedy this by choosing the number of pages and copies to
print but would like to be able to skip this step.

Thanks for the help.
BabyATX13 - 31 Mar 2005 22:09 GMT
Hi Brian
did you change anything in your table after you created the report?
KB
Brian_G. - 31 Mar 2005 22:13 GMT
Correction to the question:  I am printing a report with an embedded subform.

> Hello.  I'm trying to troubleshoot why a form I designed is printing multiple
> copies (an entire report for each record) instead of one when I hit the
[quoted text clipped - 10 lines]
>
> Thanks for the help.
BabyATX13 - 31 Mar 2005 22:40 GMT
Brian_G. Wrote

Correction to the question:  I am printing a report with an embedded
subform.

Brian,
Do you mean you are printing a report with an embedded subreport?
If so let me look some more, I’ll see what I can find.
KB
BabyATX13 - 31 Mar 2005 22:24 GMT
Brian,
Check to see if your tables have the correct relationships in your query
this may be the problem.
KB
Brian_G. - 31 Mar 2005 22:31 GMT
Thanks.  I'll check this out.

> Brian,
> Check to see if your tables have the correct relationships in your query
> this may be the problem.
> KB
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.