PDF files from Access.

T

tom

Using Google, I searched for PDF solution for
emailing docs. PDF seems like the only good solution
and nobody responded to my earlier post for better
solution.

Does anybody have good method to convert
Access report to PDF files?

Using Google came with a whole horde of solutions,
but too many solutions makes it hard to find good one.
 
A

Albert D. Kallal

tom said:
Using Google, I searched for PDF solution for
emailing docs. PDF seems like the only good solution
and nobody responded to my earlier post for better
solution.

Does anybody have good method to convert
Access report to PDF files?

http://www.lebans.com/reporttopdf.htm


The above is free, does not require you to install a pdf printer driver, or
even install any other application.

Keep in mind that for a2007, pdf ability is built in. However, if using
pre-2007, then Stephans solution is a great soltion as you don't have to
mess around with printer stuff...
 
D

Daniel Pineault

One of the simplest and best solution that I have had the pleasure of using
can be found at

http://www.lebans.com/reporttopdf.htm

No software to install of configure. It is a drop into place and use
solution. It actually gives me more reliable results than using Adobe
Acrobat professional!!!

Easy to setup, Easy to use and best of all it is free!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
T

Tony Toews [MVP]

tom said:
Using Google, I searched for PDF solution for
emailing docs. PDF seems like the only good solution
and nobody responded to my earlier post for better
solution.

Actually you got two replies to your previous posting. I just posted
a reply.
Does anybody have good method to convert
Access report to PDF files?

Lebans is an excellent solution.

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm
Using Google came with a whole horde of solutions,
but too many solutions makes it hard to find good one.

Exactly. Much better to ask in these newsgroups/forums.

Tony
 
T

tom

I downloaded the Lebans database, but I am
a little confused on how to use it.

Do I just merge this database with the one that I have?

If that is the case how do you do that?
 
A

Albert D. Kallal

tom said:
I downloaded the Lebans database, but I am
a little confused on how to use it.

Do I just merge this database with the one that I have?

If that is the case how do you do that?

Just go file->get external data...and browse to Stephens sample.

You then simply select all of the code modules, and import them....

How in the past did you move a form or report or table from one application
to another? -- so, the above is the general way to do this.

After that, to create a pdf report, in code you can go:


Call convertReportToPdf("rptOneYear")

the above will display/show the report with you pdf viewer.

You can also specify a pdf output name:
call convertreporttopdf("rptOneYear",,"c:\myReport.pdf")

And, if you don't want the report to "display"/launch the pdf, then go:

call convertreporttopdf("rptOneYear",,"c:\myReport.pdf",,False)

The only issue here is that you MUST place the dynapdf.dll and the
StrStorage.dll in the SAME directory as where your access application is
placed (the same dir as the front end - a mdb, or mde).
 
J

johnwhite402

Using Google, I searched for PDF solution for
emailing docs.  PDF seems like the only good solution
and nobody responded to my earlier post for better
solution.

Does anybody have good method to convert
Access report to PDF files?

Using Google came with a whole horde of solutions,
but too many solutions makes it hard to find good one.

You can use the pdf converter here:http://www.allpdftools.com/pdf-
converter.html#10068
 

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

Top