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"
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"