Report to PDF with different file name & file.

[WinoLa]

Hi All,

I want to convert my report to PDF file which i can be done by sourcing
reporttoPDF from this website. The program works great. But I have a problem
now is that my report for say 100 pages and i want to save 100 pages of them
into 100 different PDF file. The name of the file will also be a different
name .pdf rather than it is the report name (by default) .pdf

The file name which I want to be name as .pdf, the field is in my report.

Do I ring anyone's bell? Please help.
Thks in advance

 

[Tony Toews [MVP]]

I want to convert my report to PDF file which i can be done by sourcing
reporttoPDF from this website. The program works great. But I have a problem
now is that my report for say 100 pages and i want to save 100 pages of them
into 100 different PDF file. The name of the file will also be a different
name .pdf rather than it is the report name (by default) .pdf

The file name which I want to be name as .pdf, the field is in my report.

Presumably there is some field which makes up each page. For example
a customer, employee or invoice number or such. You need to create
a query based on that field whatever it might be.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required.
http://www.lebans.com/reporttopdf.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[WinoLa]

Hi Tony,

Thanks alot. I used the A2000ReportToPDF and it works great.
Just need to do some changes to the codes and it works in the way i wanted.

Thks once again.

 

[Tony Toews [MVP]]

Thanks alot. I used the A2000ReportToPDF and it works great.
Just need to do some changes to the codes and it works in the way i wanted.

Thks once again.

You're quite welcome.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/