Print Page 1, etc.

B

Beverly76

What vb code do I use to print page one of a report for example.

I want to print odds, then evens. I believe I could do this with a series
of print page commands.

Please help.
 
F

fredg

What vb code do I use to print page one of a report for example.

I want to print odds, then evens. I believe I could do this with a series
of print page commands.

Please help.
Click to expand...

If you wish to print all the odds (or all the evens) then see the
Microsoft Knowledge base article:
101075 "How to print odd or even pages of a report"

However, to print just one or a group of pages see the PrintOut method
in VBA help.
 
B

Beverly76

Thank you.

This article helped. I even got it to work on my report. The problem is it
prints blank pages after every page. This is a big problem because I am
trying to avoid a lot of excessive handling of the papers while printing on
both sides.

I'd like to go back to my first qustion. How do I use code to print just
page one of a report, or just pages 2-3, etc. When I print from the menu, I
have the option to print from page x to page y.

If I could do this with code, I think I could get the result I'm looking for.

Thanks in advance.
 
F

fredg

Thank you.

This article helped. I even got it to work on my report. The problem is it
prints blank pages after every page. This is a big problem because I am
trying to avoid a lot of excessive handling of the papers while printing on
both sides.

I'd like to go back to my first qustion. How do I use code to print just
page one of a report, or just pages 2-3, etc. When I print from the menu, I
have the option to print from page x to page y.

If I could do this with code, I think I could get the result I'm looking for.

Thanks in advance.
Click to expand...

I gave this information in my post::
However, to print just one or a group of pages see the PrintOut method
in VBA help.

DoCmd.PrintOut acPages, 2, 6, , 3
will print 3 copies of the report, pages 2 through 6

Access is really not designed for double sided printing.
Perhaps your printer, though, has that capability.
I know my HP Deskjet printer did before I loaded Windows XP.
 
B

Brent

You may also need to look at your report setup. The extra pages may be
coming from your report page setup not fitting on one page. Look at the
margins and how you have your report headers and footers setup.
 
F

frank

Hello Fredg,

I read the article: 101075 "How to print odd or even pages of a report".
Could you please tell me how to create 'Macro Group'.

Thanks a lot!

Regards,
Frank
 
D

Douglas J. Steele

Create a new macro, typing all of what's in Section 2 of the KB article into
it (especially the Macro Name column)

Save the macro, calling it OddEven.
 
Top