Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating individual page PDF from an access report

Status
Not open for further replies.

3Dmapper

Technical User
Aug 11, 2009
1
DK
Hi,
I have no exp. in VB but I would like to print a report to separate pages with a unique filename where filename =record.
I manage to print each record on a separate page but need to chance the default file name from "report name 1.pdf, reportname 2.pdf, ect to recordname.pdf.
If I need VB please show full macro not a single line like below because I don't know how to use it (Sorry ;))
Thanks in advance!

"Call RunReportAsPDF("rptCover", "c:\temp\Report01.pdf", , PrintChoice)
DoEvents
Call RunReportAsPDF("rptOverview", "c:\temp\Report02.pdf", , PrintChoice)
DoEvents"

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top