Print A Form Double-Sided

[Guest]

Just like to know if there's a code that I could write to print a form
double-sided.
Thanks.

Chai

 

[Douglas J. Steele]

First of all, forms aren't intended to be printed: that's what reports are
for.

Second, duplex printing is a function of the printer and the print drivers,
not of Access.

 

[Guest]

Okay, I can copy a form over as a report. I've set the printer to print
duplex. What I want to is write codes to print two different forms. Can
this be done?

For Example, I have frmForm1 and frmForm2, will the codes below work?

stDocName = "frmForm1"
stDocName = "frmForm2"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" & Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close

 

[Douglas J Steele]

That'll only print one form (frmForm2, since that's the only value that
would be stored in stDocName)

You could try:

stDocName = "frmForm1"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" & Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close

stDocName = "frmForm2"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" & Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close


Of course, you're still trying to print forms, and as I already told you,
forms aren't intended to be printed.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Okay, I can copy a form over as a report. I've set the printer to print
duplex. What I want to is write codes to print two different forms. Can
this be done?

For Example, I have frmForm1 and frmForm2, will the codes below work?

stDocName = "frmForm1"
stDocName = "frmForm2"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" & Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close

First of all, forms aren't intended to be printed: that's what reports are
for.

Second, duplex printing is a function of the printer and the print drivers,
not of Access.

 

[Guest]

I already tried the codes you suggested, but it sends out two print job.
What I want is to have it print two different forms with one print job.
Also, is there a way to print one sheet landscape and another portrait?
Thanks.

That'll only print one form (frmForm2, since that's the only value that
would be stored in stDocName)

You could try:

stDocName = "frmForm1"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" & Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close

stDocName = "frmForm2"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" & Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close


Of course, you're still trying to print forms, and as I already told you,
forms aren't intended to be printed.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Okay, I can copy a form over as a report. I've set the printer to print
duplex. What I want to is write codes to print two different forms. Can
this be done?

For Example, I have frmForm1 and frmForm2, will the codes below work?

stDocName = "frmForm1"
stDocName = "frmForm2"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" & Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close

First of all, forms aren't intended to be printed: that's what reports are
for.

Second, duplex printing is a function of the printer and the print drivers,
not of Access.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Just like to know if there's a code that I could write to print a form
double-sided.
Thanks.

Chai

 

[Douglas J. Steele]

Sorry, but there's no way to combine two reports (or forms) into a single
print job, nor can you change the orientation.

If you use a report, you can have two subreports on a single report, so that
printing the one report will print both subreports.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I already tried the codes you suggested, but it sends out two print job.
What I want is to have it print two different forms with one print job.
Also, is there a way to print one sheet landscape and another portrait?
Thanks.

That'll only print one form (frmForm2, since that's the only value that
would be stored in stDocName)

You could try:

stDocName = "frmForm1"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" &
Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close

stDocName = "frmForm2"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" &
Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close


Of course, you're still trying to print forms, and as I already told you,
forms aren't intended to be printed.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Okay, I can copy a form over as a report. I've set the printer to
print
duplex. What I want to is write codes to print two different forms.
Can
this be done?

For Example, I have frmForm1 and frmForm2, will the codes below work?

stDocName = "frmForm1"
stDocName = "frmForm2"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" &
Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close


:

First of all, forms aren't intended to be printed: that's what
reports are
for.

Second, duplex printing is a function of the printer and the print drivers,
not of Access.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Just like to know if there's a code that I could write to print a
form
double-sided.
Thanks.

Chai

 

[Imon]

How i use this code in access 2007 pls help me

stDocName = "frmForm1"
stDocName = "frmForm2"
stLinkCriteria = "[tblTestIndex.Lab No]=" & "'" & Me![tblTestIndex.LAB
NO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.PrintOut
DoCmd.Close