Convert Access report to PDF from Access via VBA code

[ShanVel]

Hi folks,
Does anyone know how to convert access report to PDF via VBA by clicking a button?

I am building a report on the fly which will be based on:
- selecting a project through a combo box
- and building a query by joining several tables related to that project
and then I should export this with a button below the combo box labeled as ''Export to PDF".

Currently, as you notice in the form (attached) I have two buttons, one “Preview” and another one “Export”. The preview button will display the access report with some formatting features. Once the user views the report in access, then they can export to excel by clicking the “Export” button. It exports to excel exactly as access reports with all formatting and open the excel application and show the report in excel and now the user can save this as an excel file. It works perfectly fine. I have a request from the customer to create a button for exporting to PDF so that no can change the data.
So, I would like to do the same with another button like excel to export to PDF. Any tips/helps are greatly appreciated. I am using Access 2003.

 

[pbaldy]

I use this to export to PDF:

http://www.lebans.com/reporttopdf.htm

 

[Mike375]

I also use Lebans.

There is also PDFCreator but the big plus of Lebans is you download an Access DB and then you have a freehand. I basically have Lebans stuff in between what I make.