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



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