Creating Acrobat reports via MS Access and VBA
Posted on 2007-04-01
I have an Access database, that allows me to be able to run reports, export them to XLS, CSV, Snapshot etc and then email the required files as attachments - this works perfectly for most clients. However, one of my clients has Apple Macs and require the graphical (Snapshot) file. Unfortunately, I do not believe that Snapshot is supported under Macs (but if I am wrong please let me know - it would make my life far easier). The solution I developed ment creating a Word document, running a mail merge and sending them this file - but this is cumberson.
Acrobat seems like the right solution, but only a couple of my clients have it and it needs to be integrated into Access - so I can create the PDF and then add it as an attachment. Since not all of my clients have the Acorbat writer, I would need to use late binding and a check to see if the PC has the Acrobat writer installed before running the report. I believe there is a SDK - but have not experience in writing the VBA code for such a process.
Any help would be really appreciated.