Solved

Creating Multi Page Letters As One Report

Posted on 2014-01-21
7
443 Views
Last Modified: 2014-01-22
I have a client that want to generate letters with up to nine pages from the database we built for them.

Each page contains some date from our DB but each page also contains paragraphs of non repetative text.  This is a law firm.

I development, I created all of the pages as individual reports with the intent of combining them onto one report for producstion.  I planned to do this by cutting and pasting from the individual reports/pages into one consolidated report, with a hard pagebreak between the pages.

That didn't work.  Even with page break controls on the report the page size will not expand enough to get more than a couple pages on.

So for right now I have the app setup to print all nine pages/reports when the option to print the letter is selected.  The reports are created in preview mode.  This creates a mess on the user screen.  Once the user verifies the content they have to print nine individual pages to get the complete output.  Not very acceptable, especially when they do these in batches.

Questions:
Is there a way to combine all the pages onto one report that I just don't know about?

Secondly, if I have to go directly to the printer with these reports rather than put them up in preview mode:  The user may not want the reports to go to their default printer.  Is there a way for the user use do that in such a way that the user can select which printer to send them to.? Although even that would be a pain since they would have to select it nine times.

Any better options?  We;ve had some unpleasant experiences with Mail merges that's why I'm trying to stay away form that option.
0
Comment
Question by:mlcktmguy
  • 4
  • 3
7 Comments
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 39799143
Is there a way to combine all the pages onto one report that I just don't know about?
Yes, Use sub reports.

You can place each of the nine reports on a report as sub reports.


Is there a way for the user use do that in such a way that the user can select which printer to send them to.? Although even that would be a pain since they would have to select it nine times.

Sure. Use the Application Printer object. The user would only  have to set the printer once for all reports.

Any better options?  
I like to store  all the paragraph text in a table. I generate lot of contracts using this method.  I have one client with contracts that are over 25 pages of text. It use a single report.
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39799175
How do I use the application printer object.  I am opening the reports with
Docmd.OpenReport "ReportName",acpreview
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 39799203
You would use the Application.Printer object to set the printer before printing the reports not preview them.

Docmd.OpenReport "ReportName1"
Docmd.OpenReport "ReportName2"

About the printer object, see:  Programming Printer Settings in Microsoft Access 2002 and later

I use the Printer object to send reports to different printers and/or trays automatically without the users having to do anything.  Cover letters to letterhead, Contracts to legal paper, envelopes to the envelope printer. etc.  all with the click of a single button by the user.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 1

Author Closing Comment

by:mlcktmguy
ID: 39799206
Thanks you so much, the sub report idea works perfectly.

I'll post this as another question if you like but since you are also working with legal output have you figured out a way to bold or underline one word or maybe even one sentence in the middle of a paragraph?

The way I'm doing it with text boxes, either the entire paragraph is bold or none of it is.

Thanks again or the sub report tip.
0
 
LVL 21
ID: 39800192
Glad to hear the sub report trick worked for you.

have you figured out a way to bold or underline one word or maybe even one sentence in the middle of a paragraph?
Sure, use the new Rich Text formatting in Access 2007 and later.

If you will need more assistance with this then it would be best to start a new question.
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39800229
Yes I was aware of the RTF available in later versions but they are still in 2003.  Soon to move to 2010 but right now RTF isn't an option.

Thanks for your help on the original question.
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39802137
I posted a followup question on this topic.

I tried using the sub-report technique this evening on a nine page report.  What worked so well last night did not tonight.  Please see this question:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28345909.html
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now