Anyone with a clever idea for printing last page?

  • Thread starter Thread starter REM7600
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top