print to pdf-number of pages

K

ken

i have ~100 reports which i need to print to pdfs. all reports should be two
pages. sometime three pages get printed due to errors or other reasons. i
send the reports to a pdf via docmd.outputto pdf. i would like to track for
each report, the total number of pages sent for each report. how can i do
this.
 
A

Alex Dybenko

Hi,
you can open report in preview, but hidden, before printing to PDF and get
it number of pages using Pages property:

docmd.OpenReport strReport,acViewPreview,,,acHidden
debug.print reports(strReport).Pages
docmd.close acReport, strReport

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 

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

Similar Threads

Print (physical or pdf) not respecting format of source document 0
Page numbering with Merged Document and IF statements 1
Some pages of publisher do not get printed with MS PDF 1
Space at end of multi page list to accommodate new entries 1
VBA Export to PDF 0
Office 2010, background images do not appear in print preview nor print 0
Script to print to pdf a word document with pdf linked as objects 5
Converting excel to PDF, single page converts to multiple HELP! 1

Top