Hello helper community.
To create with vba a PDF file from a Report i need the reference to pdfcreator.tbl.
Where can i find it?
Downloading PDFCreator and PDF Architect didn't help.
Thank you for any hint,
Walter
Hello helper community.
To create with vba a PDF file from a Report i need the reference to pdfcreator.tbl.
Where can i find it?
Downloading PDFCreator and PDF Architect didn't help.
Thank you for any hint,
Walter
You don't need PDF creator.
use Docmd.outputTo
DoCmd.OutputTo acOutputReport, "Employees", acFormatPDF, "c:\Employee.pdf, True
well, i read that the quality is very poor, but thanks for the answer.
This is the beginning of the code i'd like to use:
Public Function PrintReportPDFCreator(strReportName As String, strFileName As String) As Boolean
Dim OldPrinterName As String, PDFPrintername As String
Dim PDF As PDFCreator.PdfCreatorObj
Dim PDFQueue As New PDFCreator.Queue
Dim MyJob As PDFCreator.PrintJob
Dim PDFDevices As PDFCreator.Printers
suggest try it before you knock it. It's not print quality you can send to a printing company to print a brochure or catalogue - but then neither is pdf creator.i read that the quality is very poor,
With regards pdfcreator - if you read the thread from where you got this code you will see you need to set a reference in the library. https://forums.pdfforge.org/t/using-...-office/7682/2
Yes, you are right: i stumbled over the thread you mention and thought this to be the best and easiest solution. And to run it, i have to include a reference to pdfcreator.tbl, shouldn't i? And that was the motive of my question, how to get this library, so i could set the reference.
But as you suggest, i'll try to create the pdf with docmd.
I'll let you know, if this works out. Thanks.
if you have downloaded and installed the app, the library should be there. In the vba window, go to Tools>References and scroll down until you find it - then select it. If this is for a multi user system, each user will need the app installed on their machine.
If you haven't downloaded it, it can be downloaded from here https://www.pdfforge.org/pdfcreator/download
Note - if this is for a multi user system, each user will need the app installed on their machine.
Now everything is as i needed. Thank you.
Hi again
You wrote
and i did had downloaded PDFCreator. Under the references i found "PDFCreator_COM" and thought "this is it".If you haven't downloaded it, it can be downloaded from here https://www.pdfforge.org/pdfcreator/download
But the code can't be compiled: "Type not defined" at the set command; selecting PDFActiveDoc produces the same error at the dim command
The mentioned thread i got the code from says to have a reference to "PDFCreator.tlb", which is not listed under the available references:Code:Dim PDF As PdfCreatorObj ... Set PDF = New PDFCreator.PdfCreatorObj
So i come back to my original question: where do i get PDFCreator.tbl?
Because with doCmd OutputTo the PDF gets nicely created, but i have to add a password, which is not possible with this method.
Do you have any other idea?
sorry, no suggestions other than go to the developer, perhaps google 'pdfcreator' and 'pdfcreator.tblm see what hits you get. Or use the access built in pdf creator - at least see if quality really is an issue. Only other thought is to use a pdf printer such as cutepdf. Just be aware that all the free stuff will tend to generate larger files. Use acrobat for higher quality/smaller files but this involves a license fee.
Edit: have you checked whether there is a file called pdfcreator.tbl on your machine? I would expect to find it in a 'pdfcreator' folder c:\program files or c:\program files (x86). If so, in the vba references window, you can try browsing to it to install
Another thought perhaps pdf creator is a 32bit app and you are running 64bit access? in which case you will have a compatibility issue