print report pages 1 by 1

[longranger]

hello

we have a report we print in our letter feed for warranty cards there is usually 10 cards at a time we need to have it print page by page
so it prints the first page then a msg box appears asking do we wish to print second and so on. is there anyway we can do this?

 

[Adeptus]

Depending on the printer, you can set it to treat manual feed as a separate cartridge, ie you tell it to print from manual feed and it will wait until there is paper in manual feed to print on.

I believe printer settings are saved for each report, so if you set it to use manual feed, it will always use manual feed.

Alternatively, make a form that you print the report from. Have it filter the recordset sent to the report, so that it only sends one page worth at a time.