Is there a way to easily export an Access Report to PDF. I know there are PDF printers I can use but I want to change the file name programatically and then attach it to an email without any user intervention.
Does anyone know of a ActiveX control, Access Add-on or something similar?
The reason I want to use PDF instead of SNP is because Acrobat Reader is almost standard nowadays whereas SNP is not. I have developed applications in VB.NET using Crystal Reports and exporting them as PDF. All our clients are used to receiving PDF Files from us.
I need to do this project in Access so that the user can work with the tables and write their own queries.
I Guess the only other solution is to add a Crystal Report Viewer into Access and exporting the file that way. A bit more code but what the heck.