My Assistant
![]() ![]() |
|
|
Aug 28 2007, 08:30 AM
Post
#1
|
|
|
New Member Posts: 9 |
Is there any way for me to print double sided with some constraints?
I have a database that is printing 5-6 (3 double sided) page letters. If the letter is 6 pages I am fine, it just finishes one letter on the back side of a page and begins a new page for the next letter. My problem is for a 5 page letter it wants to print the last page of the letter on the front of a page then begin printing the next letter on the back of the same page. Is there any way around this to get a new letter to start on the front of a new page of paper? Thanks Steve |
|
|
|
Aug 28 2007, 09:40 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 7,394 From: Oadby Leics, UK |
Add a page break control to your report at the 'end' of the letter design - i assume that this must be in a group footer section , but that is not really important, except that you know where it is.
Then in the Format event procedure for that section check the page number and make the control visible or invisible: If Me.Page Mod 2 = 0 then ' currently an even page Me.pgBreak.Visible = true else Me.pgBreak.Visible = false end if |
|
|
|
Aug 29 2007, 02:52 PM
Post
#3
|
|
|
New Member Posts: 9 |
I'm trying this but its not working. Its not recognizing the method of pgBreak. Is this a new method in a new version. I am running on Access 2000. I looked through other available methods and I'm not finding anything that will do this.
|
|
|
|
Aug 29 2007, 05:17 PM
Post
#4
|
|
|
New Member Posts: 6 |
Hi, I am trying to print double sided. Can you please help me in that?
|
|
|
|
Aug 29 2007, 05:35 PM
Post
#5
|
|
|
UtterAccess VIP Posts: 7,394 From: Oadby Leics, UK |
'pgBreak' must be the name of YOUR pagebreak control.
|
|
|
|
Aug 29 2007, 05:59 PM
Post
#6
|
|
|
New Member Posts: 6 |
I am sorry, I am new to VBA. I didn't understand you
|
|
|
|
Aug 30 2007, 12:56 AM
Post
#7
|
|
|
UtterAccess VIP Posts: 18,396 From: Oklahoma City, Oklahoma |
Jumping in ...
From the Control Tool box, add a page break control to the report. Then you will be able to use the suggested code. |
|
|
|
Aug 30 2007, 08:16 AM
Post
#8
|
|
|
New Member Posts: 9 |
Whoa, brain malfunction...
Thanks guys it works perfectly. Now I just need to figure out how to turn the group header off for that blank page that I had set to repeat section. Thanks again. |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 09:34 AM |