UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Double Sided Printing    
 
   
smdemo
post 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
Go to the top of the page
 
+
Peter46
post 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
Go to the top of the page
 
+
smdemo
post 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.
Go to the top of the page
 
+
devryimax
post 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?
Go to the top of the page
 
+
Peter46
post 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.
Go to the top of the page
 
+
devryimax
post 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
Go to the top of the page
 
+
HiTechCoach
post 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.
Go to the top of the page
 
+
smdemo
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 09:34 AM