Print dialog box with Page Range selection option with VBA?

G

Gary

I have seen Print dialog box help on the server. What I need is a print
dialog box which will allow the user to select the range of pages to be
printed.

I have seen:

Docmd.RunCommand acCmdPrint

This doesn't have that option to select the range of pages to be printed.

Can someone Please help!

Thanks,

Gary
 
J

Jim Burke in Novi

If you just do a print preview rather than a print, then while viewing the
report the user should be able to select File, Print..., which will bring up
the options you want.
To do a print preview use:

DoCmd.OpenReport "report name", acViewPreview

If you don't specify acViewPreview, I'm pretty sure the default is to just
print the document without giving you any options.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Print order of TriFold - Publisher 365 0
Publisher adding blank page when printing my booklet... 2
Space at end of multi page list to accommodate new entries 1
Insert Multiple Fields without Dialog closing between each... 0
macOS Office365 Word 0
Printing Outline view - formatting lost 0
Print Dialog Box 1

Top