Access and PDFCreator


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


Hi Lisbeth,

yes this should all be possible through VBA and the PDFCreator's COM interface:
You can also find a VBA example inside the PDFCreator program folder\COM Scripts.

Best regards