converting report to pdf file via VBA

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
does anyone have code sample of how to make a report to be a pdf file
via VBA
i know that there is a program called pdf995 but i want to make it
independently from the access
 
I don't understand what you mean by "independently from the access". Access
does not have any built-in method to create PDF files: you must use a 3rd
party product.

The easiest approach is probably what Stephen Lebans has at
http://www.lebans.com/reporttopdf.htm
 
Yes, there is a pdf converter at Stephan's site:

the advantages are:

* you don't need to install a printer driver, nor does your code need to
"switch" printers
* you don't need to install any other software !!!
* you don't need to purchase adobe, or something like pdf995 - it is
free

* Stephens code example is really nice, as you can set the pdf output
file name in code with GREAT ease and not bother will funny code to switch
printers etc....

You can find it here:
http://www.lebans.com/reporttopdf.htm

There is good, and then there is great - Stephens solution = great!!
 
Back
Top