checking number of pages in report

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

How could I check from VB a number of pages in a report to
alert a user before printing if there are many pages?

Thanks
 
You should check the help files before making a post to a
news group.
This is directly from teh visual basic help files for
access.
Dim intTotalPages As Integer
Dim strMsg As String

intTotalPages = Me.Pages
strMsg = "This report contains " & intTotalPages & "
pages."
MsgBox strMsg
 

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

Obtain report page count with out previewing the report. 2
A03 - count in report footer gives me #Error? 0
Group last line of details and report footer 0
Saving page number from report 5
Page numbering by page of record 6
Page numbers don't appear in subreport 1
Report - Don't print the page footer on the last page 6
Printing of sub-report skips to second page. 3

Back
Top