A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

print odd pages or even pages



 
 
Thread Tools Display Modes
  #1  
Old April 2nd, 2010, 05:09 PM posted to microsoft.public.access.reports
Russ[_2_]
external usenet poster
 
Posts: 52
Default print odd pages or even pages

I'm trying to make a booklet style report and would like Access to
print the odd numbered pages, and then I can put the paper back in the
printer and hopefully print the even numbered pages backwards on the
other side. Any way of printing like that?
  #2  
Old April 3rd, 2010, 09:06 PM posted to microsoft.public.access.reports
Russ[_2_]
external usenet poster
 
Posts: 52
Default print odd pages or even pages

Hey, folks... don't let the 'printing in reverse order' scare you. If
anyone knows how to pring just odd or just even pages I could sure use
that all by itself.

On Fri, 02 Apr 2010 11:09:45 -0500, Russ wrote:

I'm trying to make a booklet style report and would like Access to
print the odd numbered pages, and then I can put the paper back in the
printer and hopefully print the even numbered pages backwards on the
other side. Any way of printing like that?

  #3  
Old April 5th, 2010, 01:34 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default print odd pages or even pages

The only thing I can think of is to try using something like Clickbook.

http://www.bluesquirrel.com/products/clickbook/

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Russ wrote:
Hey, folks... don't let the 'printing in reverse order' scare you. If
anyone knows how to pring just odd or just even pages I could sure use
that all by itself.

On Fri, 02 Apr 2010 11:09:45 -0500, Russ wrote:

I'm trying to make a booklet style report and would like Access to
print the odd numbered pages, and then I can put the paper back in the
printer and hopefully print the even numbered pages backwards on the
other side. Any way of printing like that?

  #4  
Old April 5th, 2010, 11:42 PM posted to microsoft.public.access.reports
Russ[_2_]
external usenet poster
 
Posts: 52
Default print odd pages or even pages

Sounds like it might work John, but I've only got 3 or 4 pages to
print on the Access report. I noticed that MS Word will print
odd/even pages, but Access won't do it. Maybe export to an rtf file
then get it from word there. Too bad Access can't do that directly.

I was hoping someone had developed some code to get by this
shortcoming.

On Mon, 05 Apr 2010 08:34:03 -0400, John Spencer
wrote:

The only thing I can think of is to try using something like Clickbook.

http://www.bluesquirrel.com/products/clickbook/

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Russ wrote:
Hey, folks... don't let the 'printing in reverse order' scare you. If
anyone knows how to pring just odd or just even pages I could sure use
that all by itself.

On Fri, 02 Apr 2010 11:09:45 -0500, Russ wrote:

I'm trying to make a booklet style report and would like Access to
print the odd numbered pages, and then I can put the paper back in the
printer and hopefully print the even numbered pages backwards on the
other side. Any way of printing like that?

  #5  
Old April 6th, 2010, 05:52 AM posted to microsoft.public.access.reports
trevorC via AccessMonster.com
external usenet poster
 
Posts: 37
Default print odd pages or even pages

Get a better printer, they can do that now. (Big ones anyway) Or print each
page to a pdf file then use pdf viewer or word to print them.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201004/1

  #6  
Old April 6th, 2010, 05:57 AM posted to microsoft.public.access.reports
trevorC via AccessMonster.com
external usenet poster
 
Posts: 37
Default print odd pages or even pages

Or you could try this -

make boxes to cover all report sections, change thier color to white
foreground and white back color. Then set them to Visible = false and not
transparent.

Now use some code to get the page number, if it's odd then make the boxes
visible (Just leaves a blank page, i use this to not print on used labels)
Just swap it around for the Even pages.

--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.