Anyone with a clever idea for printing last page?

R

REM7600

Anyone got a clever sample of how to print only the last page of a report?
I've looked through the properties and such and haven't found quite what I'm
looking for...

Thanks!

Travis
 
R

REM7600

Sorry, this should have referenced that I'm trying to automate this with
VBA. will run on a schedule and kick off a macro which sends the reports
only if there's data AND only the last page (it's for an ongoing hard copy
LOG of events that is required of the organization.)

I was hoping for a me(rpt).Printer.Pages property that I could set via VBA
after getting the me.Pages value.

Sorry if I was unclear the first time...

TR
 
R

REM7600

OK OK... AccessWeb to the rescue again... Sorry to bother the group. Will
look there FIRST next time

DoCmd.OpenReport "myReport", acViewPreview
theNumPages = Application.Reports.Item(0).Pages
DoCmd.PrintOut acPages, theNumPages, theNumPages
 
Top