Re: Report to PDF with different file name & file.

Tech-Archive recommends: Speed Up your PC by fixing your registry

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.
--
Rdgs
WinoLa


"Tony Toews [MVP]" wrote:

WinoLa <WinoLa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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/

.

Relevant Pages

  • Re: Send email ?
    ... Base on my records I need to send 200 emails separately with attached report ... PDF files is Stephen Lebans solution. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Send email ?
    ... columns) and I have one report Letter. ... Base on my records I need to send 200 emails separately with attached ... PDF files is Stephen Lebans solution. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Report to PDF with different file name & file.
    ... reporttoPDF from this website. ... now is that my report for say 100 pages and i want to save 100 pages of them ... into 100 different PDF file. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Snapshot file
    ... > I have a snapshot file that is of a report that I ... > created with Microsoft Access. ... You could save it as a PDF - with the report ...
    (microsoft.public.frontpage.programming)
  • Re: why>?
    ... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
    (microsoft.public.excel)