Booklet Report

[Guest]

Relative newcomer looking for some help. I have created a contacts database
and would like to print the data in a booklet form. The pages will be
landscape with the data for the first page of my booklet on the left half of
the landscape paper and the data for the last page of my booklet on the
right. The following sheets of paper will be printed the same way until the
final paper has the exact middle info on the left and right side of the page.
When I stack the papers, fold in the middle and staple, the info will be in
alphebetically order. Possible at all? Thanks in advance.

 

[Duane Hookom]

I expect this would be possible if each entry took the same amount of space
so there was a constant number of contacts on each page. You would need to
create a page number calculation in the report's record source so the
report's sorting and grouping could be used to print in the proper order.

 

[Allen Browne]

Access is not capable of performing the imposition for your layout.

Any chance of performing a merge into a program that can?
I haven't used Publisher for this but it should be up to it.

 

[Van T. Dinh]

Another possibility (*I think*) is to automate Word by creating a new
document based on a "folded-booklet" template with a Word Table in the
template. Traverse through the Recordset of contacts and fill a Word Table
with contact details.

Both Word 2002 and 2003 have Help topic on "Folded booklet". Not sure about
earlier versions of Word.

 

[Chuck]

Relative newcomer looking for some help. I have created a contacts database
and would like to print the data in a booklet form. The pages will be
landscape with the data for the first page of my booklet on the left half of
the landscape paper and the data for the last page of my booklet on the
right. The following sheets of paper will be printed the same way until the
final paper has the exact middle info on the left and right side of the page.
When I stack the papers, fold in the middle and staple, the info will be in
alphebetically order. Possible at all? Thanks in advance.

Yes. This is possible. Your instructor gave you this problem to make you
think. A booklet as you describe is not nearly as practical as it sounds and
it gets less practical as the number of pages increases. To satisfy your
instructor you need to make a query that does the sorting for you. It isn't
very difficult, but it does require thought.

On the off hand chance you really need/want this thing: From Bob Howard:
"finally decided to use a software product called FinePrint
(www.fineprint.com) which acts as a Postscript printer. I give it the
appropriate settings to configure the result as a booklet, and it takes care
of the whole thing." (snip) about $50.00

Just a wizard prodder
Chuck
--

 

[Guest]

Thank you all for your help. It is a curious problem. I am trying some of
your proposals. The project was not for a class but for a small directory
for our church members. Thanks again.

 

[Larry Linson]

There are third-party products that do just what you want -- one I have used
in the past but not recently is ClickBook by Blue Squirrel Software. It's
not free, but it is dead easy -- installs as though it were a printer.

I know there are software packages, e.g., MS Publisher and MS Word, with
similar functionality built-in, but then you face the complexity of first
exporting to those packages and then printing. And, I strongly suspect there
are other similar third-party packages.

Larry Linson
Microsoft Access MVP