I would like to to like this
- open a report in Access and preview it
- OnClose print a PDF where location is same as database and name is created from name- number field in Query that creates report
- mail pdf to email-adress also in Query
Is this possible?
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.
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…