Define number of pages to print

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi All!

I have a report that increases the date by one month for each page... a
payment book for monthly payments.

The problem is that the clients have various number of payments. One
customer will pay every month for 6 months and another every month for 4
months etc.

I want to be able to define how many pages to print, based on a
parameter the user will input when the report opens.

Any ideas greatly appreciated!

Jeff
 
Hi All!

I have a report that increases the date by one month for each page... a
payment book for monthly payments.

The problem is that the clients have various number of payments. One
customer will pay every month for 6 months and another every month for 4
months etc.

I want to be able to define how many pages to print, based on a
parameter the user will input when the report opens.

Any ideas greatly appreciated!

Jeff
Click to expand...

Input where?
On the form used to open the report?

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.PrintOut acPages ,1,Me![ControlName]

Look up the PrintOut method in VBA help.
 
Back
Top