Saving Access Query as PDF (Landscape)

[MFrost]

Hi all,

I'm sure this should be possible. I'm trying to use Access 2007's built in 'Save as PDF' option to output a many queries.

I can get them to save as PDF no problems at all, but there never seems to be an option to choose to output it as PDF in a landscape orientation.

Anyone have any ideas how to do this? programatically or just through the front end.

Appologies if it's blatantly obvious and sitting right under my nose. I just cant see it!

Thanks a lot.

MFrost

 

[Trevor G]

Preview your query in Print Preview adjust the page settings to Landscape then you can save as PDF and it is then in landscape.

Yes it is fairly easy, but some of these things take you round the houses...

 

[MFrost]

Haha, so simple when you know how! Thanks a lot! You're right about taking you round the houses though!

I know this is heading towards a module/vba question, but would you happen to know how change this to landscape using vba? I can get the query to open in print preview mode using vba, but cant find out how to reference the damn landscape button in code.

Thanks again.

MFrost

 

[Trevor G]

You need to add the printer command something like this

Sub openQuery()
DoCmd.openQuery "qryName", acViewPreview
Printer.Orientation = acPRORLandscape
End Sub