Hi, I have a report that has 150 pages. I would like to tell the printer to print the first 25 pages, perhaps the next 15 and then 20 or 15 for example. How do I accomplish this task using reports, macros or VBA?
Thanks GHolden; I should be more specific. When I choose a button to print a specific report (which i use a preview to check) I would like to receive a prompt that asks me to select the pages to print, similar to the one found when I choose print from the menubar and I change the properties. Being able to chunk up the report or be selective as to the pages I want is key. Itis not always necessary to print the whole report and each printing may require diff pages. Any other suggestions since printout assumes I will know the pages required ahead of time which is not always the case.
If you then had two text boxes on a form (say txtStartPage and txtEndPage) and a button to print (cmdPrint), and possibly a text box for report name (txtReport)
in the click event of the command button you could have...
gPrintRange txtStartPage,txtEndPage,txtReport
You would want to add an error handler and some validation to the print sub (eg. make sure end page is greater than or equal to start page...)
Hope this is more what you're looking for...?
There are two ways to write error-free programs; only the third one works.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.