page orientation and letterhead

[christianlott1]

This is easy to do in word but is it possible in access?

I want the first page to print on company letterhead and other pages
to print on regular paper. Some of the pages I want landscape, others
I want to remain portrait.

The printer properties only allow me to set at design time. Stuff like
this doesn't work:

Private Sub Report_Page()
Select Case Me.Page
Case 1
Me.Printer.Orientation = acPRORLandscape
Me.Printer.PaperBin = 1
Case 2
Me.Printer.Orientation = acPRORPortrait
Me.Printer.PaperBin = 2
End Select
End Sub
---------------

Any way to allow this to be set at runtime? This is a huge mailing and
hand collation is not an option.

Maybe there's a web page to show me how to use word to do this?

One of the problems is that there are lists of items that must be
printed in the report - a job for the 'subreport'. It's not just a
simple merge.
Christian

[salad]

ch************@yahoo.com wrote:

This is easy to do in word but is it possible in access?

I want the first page to print on company letterhead and other pages
to print on regular paper. Some of the pages I want landscape, others
I want to remain portrait.

The printer properties only allow me to set at design time. Stuff like
this doesn't work:

Private Sub Report_Page()
Select Case Me.Page
Case 1
Me.Printer.Orientation = acPRORLandscape
Me.Printer.PaperBin = 1
Case 2
Me.Printer.Orientation = acPRORPortrait
Me.Printer.PaperBin = 2
End Select
End Sub
---------------

Any way to allow this to be set at runtime? This is a huge mailing and
hand collation is not an option.

Maybe there's a web page to show me how to use word to do this?

One of the problems is that there are lists of items that must be
printed in the report - a job for the 'subreport'. It's not just a
simple merge.
Christian

You want to send the 1st page to 1 printer and the rest of the report to
another printer. On the second printer print some pages in portrait,
others in landscape.

Access has a real nice report writer. It is not a word processor.

Perhaps Crystal Reports has such capabalities. You could send them a
query at their web site.

If it can be done in Word you might want to ask in a Word newsgroup
(there's quite a few) how you can write the VBA code to accomplish your
request.