Portrait / Landscape Report

  • Thread starter Thread starter andrew
  • Start date Start date
A

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
 
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
 
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
 
Back
Top