Tony Septav
iggy at nanaimo.ark.com
Fri Jul 27 08:15:09 CDT 2007
Hey Michael
Thanks
No error messages.
I think it has to be a printer problem or
I am missing a turn off/turn on setting in Access2003.
If I set the printer (Dell Photo Printer 720) preferences, to letter 8
1/2 by 11, portrait.
Then go into the design mode for a report (in Access98) that was set to
letter and landscape, select page setup the orientaion is set to
portrait and if I click landscape then exit (and don't do anything) and
go back in, it is back to portrait and vice a versa if I set
preferences to landscape and open a report that was set to portrait.
I tried the code below for 2003, I downloaded from Microsoft, but it
doesn't fire off the orientation setting still stays as portrait.
Dim rpt As Access.Report
Dim prtr As Access.Printer
Set Application.Printer = Nothing
Set prtr = Application.Printer
'Set the default printer's orientation to landscape
prtr.Orientation = acPRORLandscape
'Set the default printer's paper size to legal
prtr.PaperSize = acPRPSLegal
'Print Preview the Client Report
DoCmd.OpenReport "client", acPreview
Set rpt = Reports("client")
'Set the Printer property of the report to the
'Application.Printer object
Set rpt.Printer = prtr
'Uncomment the following line if you wish to save the object
'with the current settings
'DoCmd.Save acReport, "Client"
I hope I have not pulled off a "bonehead" manuever in my upgrading.
Thanks Again