Portrait / Landscape Report

[andrew]

Hi

I am using Access 2000. I have 2 separate reports. One is in portrait
mode, then other is in landscape mode. I want to combine them into a single
printout such that one side displays in portrait and the other side displays
in landscape.

Can you give me examples of VB codes that tell Access to send the reports
one after the other and print the result into a single page?


Thanks


Andrew

 

[Douglas J. Steele]

AFAIK, it's not possible.

 

[UpRider]

Andrew, here is some code to force landscape (or portrait). I'm not sure how
it applies in your case... Duplex printing depends on many variables
including the printer type. Anyway FWIW....
This code shows how to change the assigned printer also....

strDocName = "MyReport"
DoCmd.OpenReport strDocName, acViewPreview
'Lookup the printer to use for this report in the lookup
table...
strPrinter = DLookup("[sqlPrinter]", "tblSqlType", "sqlID ="
& Chr$(39) & txtSQLrec & Chr$(39))
If Len(strPrinter & vbNullString) > 0 Then
Screen.ActiveReport.Printer =
Application.Printers(strPrinter)
End If
Application.Reports(strDocName).Printer.Orientation =
acPRORLandscape
' or acPRORPortrait
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow

HTH
UpRider

 

[UpRider]

Andrew, just noticed you are using A2000. My just sent suggestion is
worthless for you. Has to be A2002 or better.
Sorry about that...

UpRider