To: MS_Access_Professionals@yahoogroups.com
From: bob@alternatefinishing.com
Date: Thu, 12 Dec 2013 07:53:46 -0500
Subject: RE: [MS_AccessPros] RE: Display a JPG on every other page in report
Hi,
I like Bill's suggestion and was wondering if it worked for you?
Bob Peterson
"Never look back unless you are planning to go that way."
― Henry David Thoreau
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Steve Conklin
Sent: Monday, December 09, 2013 5:16 PM
To: MS Access Pros List
Subject: RE: [MS_AccessPros] RE: Display a JPG on every other page in report
That sounds like it should do the job. I will give it a try. Thanks, Bill.
Steve
To: MS_Access_Professionals@yahoogroups.com
From: wrmosca@comcast.net
Date: Mon, 9 Dec 2013 14:10:05 -0800
Subject: RE: [MS_AccessPros] RE: Display a JPG on every other page in report
Ah, I see the problem. You need to force a new blank page! The only way I can think of doing that is to use what usually is a mistake. Most report makers eventually make the mistake of making a line too long so that it passes the left margin by just a teeny bit. They print the report and every other page is blank because of the line. Maybe it only shows on the page as a little dot, but it's there.
Put the image control on the report far enough to the left so that it exceeds the margin. Access will automatically force a new page to accommodate the image. Then you don't need to hide/show the image. Leave it visible all the time.
Bill
---In MS_Access_Professionals@yahoogroups.com, <StephenMConklin@hotmail.com> wrote:
Hi Bill.
I have tried variations of what you suggest, but I am not quite getting there. The verbiage needs to stand alone.
Every even page needs only the disclaimer, and I have to show it on pg 2 even if there is only 1 page worth of data to the invoice. And if there is enough data for 2 pages, I need to put the next page of data on pg 3 (and disclaimer again on pg4)
And to make matters worse it is ALOT of text, takes up almost a whole page on its own.
Steve
To: MS_Access_Professionals@yahoogroups.com
From: wrmosca@comcast.net
Date: Mon, 9 Dec 2013 09:04:02 -0800
Subject: [MS_AccessPros] RE: Display a JPG on every other page in report
Steve
Since you are already using Page of Pages, you're half way there. Put a label (or text box if the verbiage is stored) and hide or show it based on even/odd pages.
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me.lblDisclaimer.Visible = (Me.Page Mod 2 = 0)
End Sub
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (16) |
Tidak ada komentar:
Posting Komentar