Print dialog box with Page Range selection option with VBA?

[Guest]

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

 

[Douglas J. Steele]

Take a look at the PrintOut method.

 

[Guest]

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.