createing a PDF from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TADropik - 09 Dec 2005 15:25 GMT

Is it possible to create a PDF from with Access 2003? I am currently able to
create Excell documents and Powerpoint presentations using code that calls on
the appropriate objects. Can this be done with a PDF file?

Reply to this Message

Rick B - 09 Dec 2005 16:01 GMT

Since ADOBE is not a Microsoft product, you will have to use a third party
PDF writer (such as cutepdf). I don't believe that Microsoft will ever make
it easy to create documents in a competitors format when they have their
"snapshot" format.

Signature

Rick B

> Is it possible to create a PDF from with Access 2003? I am currently able
> to
> create Excell documents and Powerpoint presentations using code that calls
> on
> the appropriate objects. Can this be done with a PDF file?

Reply to this Message

Stephen Lebans - 09 Dec 2005 16:14 GMT

Rick the next version of Office supports native generation of PDF documents.

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> Since ADOBE is not a Microsoft product, you will have to use a third party
> PDF writer (such as cutepdf). I don't believe that Microsoft will ever
[quoted text clipped - 6 lines]
>> calls on
>> the appropriate objects. Can this be done with a PDF file?

Reply to this Message

Rick B - 09 Dec 2005 16:19 GMT

WOW! That is surprising (and nice!!!)

Signature

Rick B

> Rick the next version of Office supports native generation of PDF
> documents.
[quoted text clipped - 9 lines]
>>> calls on
>>> the appropriate objects. Can this be done with a PDF file?

Reply to this Message

Stephen Lebans - 09 Dec 2005 16:25 GMT

Also I released a free PDF creator for Access 97 or later that creates PDF's
without requiring the installation of a PDF Printer Driver.
http://www.lebans.com/reporttopdf.htm
A97ReportToPDF is an Access 97 database containing a function to convert
Reports and Snapshot files to PDF documents. No PDF Printer driver is
required. This archive contains a new version of the DynaPDF library. Please
make sure you delete your old version.

Version 2.01 November 16/2005 12:12am

Major change to project. No more MDE! Core logic is now contained within a
standard Windows DLL named StrStorage.dll produced in C++. New version of
the DynaPDF library. Neither the DyanPDF DLL or the StrStorage DLL require
Registration or a Reference to be set in your MDB. Solution now works with
all versions of Access. Several minor bug fixes and huge increase in
execution speed.

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> WOW! That is surprising (and nice!!!)
>
[quoted text clipped - 11 lines]
>>>> calls on
>>>> the appropriate objects. Can this be done with a PDF file?

Reply to this Message

rbm - 11 Dec 2005 19:24 GMT

My apologizes to TADropik to stepping on his post, but I have a question for
Stephen. Will you be updating the A97ReportToPDF to allow lines as opposed
to boxes? I have *snp reports that work great, but I would like to convert
them to *.pdf within my application. What you have done so far is excellent!
Can't wait to see where it goes from here.

rbm

> Also I released a free PDF creator for Access 97 or later that creates PDF's
> without requiring the installation of a PDF Printer Driver.
[quoted text clipped - 12 lines]
> all versions of Access. Several minor bug fixes and huge increase in
> execution speed.

Reply to this Message

Stephen Lebans - 11 Dec 2005 22:36 GMT

As it says repeatedly in the sample MDB, I am working on this issue and hope
to have a resolution posted soon.

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> My apologizes to TADropik to stepping on his post, but I have a question
> for
[quoted text clipped - 29 lines]
>> all versions of Access. Several minor bug fixes and huge increase in
>> execution speed.

Reply to this Message

Jeff Polack - 20 Feb 2006 00:42 GMT

The Lebans code works great and is free. If you want additional information
on PDF-related issues, try this link:

http://www.granite.ab.ca/access/pdffiles.htm

> Is it possible to create a PDF from with Access 2003? I am currently able to
> create Excell documents and Powerpoint presentations using code that calls on
> the appropriate objects. Can this be done with a PDF file?

Reply to this Message

Stephen Lebans - 20 Feb 2006 00:52 GMT

Tonight I finally resolved the issue with lines generated by the report Line
tool not showing in the converted PDF. It will be a day or two before I post
the new release because I have to test the PDF compression and Security
stuff I've added in this release.

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> The Lebans code works great and is free. If you want additional
> information
[quoted text clipped - 7 lines]
>> calls on
>> the appropriate objects. Can this be done with a PDF file?

Reply to this Message

SA - 20 Feb 2006 18:22 GMT

TA:

Our PDF and Mail Library for Access supports automatically outputting
reports from some of the most popular PDF drivers to files of your choosing,
with filters, bookmarks etc. Stop by our web and look in the developer
tools section.

Signature

SA
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

> The Lebans code works great and is free. If you want additional
> information
[quoted text clipped - 7 lines]
>> calls on
>> the appropriate objects. Can this be done with a PDF file?

Reply to this Message