Groups > comp.databases.ms-access > #9027

OutputTo format

From	"Phil" <phil@stantonfamily.co.uk>
Newsgroups	comp.databases.ms-access
Subject	OutputTo format
Date	2014-02-17 08:18 +0000
Organization	Aioe.org NNTP Server
Message-ID	<ldsgl8$1rn$1@speranza.aioe.org> (permalink)

Show all headers | View raw

I am using the following to create a PDF file of the image of a form.
The DLookup bit is the folder for the output file and the name of the output
file.

DoCmd.OutputTo o acOutputForm, Me.Parent!SubForms.Form!FormNameX & "Dummy",
acFormatPDF, _ DLookup("PDFPath", "QcoinfoPaths") & "\" &
Me.Parent!SubForms.Form!FormNameX & "Dummy.PDF"

My problem is that if the form is wider than it is long, I want the
orientation of the PDF to be landscape, otherwise it needs to be portrait.
The default seems to be portrait. Obviously I can compare Me.Width to the sun
of the heights of the various sections, but how do I change the orientation.
This has to be an automatic process, I don't want the user going into print
dialogue boxes.

Thanks

Phil

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

Back to comp.databases.ms-access | Previous | Next | Find similar | Unroll thread

Thread

OutputTo format "Phil" <phil@stantonfamily.co.uk> - 2014-02-17 08:18 +0000

csiph-web