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