Access and PDFCreator


#1

I would like to to like this

  1. open a report in Access and preview it
  2. OnClose print a PDF where location is same as database and name is created from name- number field in Query that creates report
  3. mail pdf to email-adress also in Query

Is this possible?

/Lissu Media
aka
Lisbeth


#2

Hi Lisbeth,

yes this should all be possible through VBA and the PDFCreator's COM interface:
http://docs.pdfforge.org/pdfcreator/3.3/en/pdfcreator/com-interface/
You can also find a VBA example inside the PDFCreator program folder\COM Scripts.

Best regards

Robin


#3

I found the Word VBA document. I have copied the VBA to Access and tried several Changes in the vba code but I can't get it working. Can anyone please send me a working Access VBA code snippet? Thanks in advanceā€¦

/Lissu Media
aka
Lisbeth