VB.NET - How to Save Access Report File as PDF

Asked By Md. Monirul Islam on 08-Oct-12 09:39 AM
Private Sub BtnPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnPrint.Click
        Dim appAccess As Microsoft.Office.Interop.Access.Application
        appAccess = New Microsoft.Office.Interop.Access.Application

        'appAccess.Visible = True 
        appAccess.Visible = False
        appAccess.OpenCurrentDatabase("D:\Backup\N&S\Test.accdb", bstrPassword:="Test", Exclusive:=False)

        appAccess.DoCmd.OpenReport(ReportName:="Product_Report", View:=Microsoft.Office.Interop.Access.AcView.acViewPreview, WindowMode:=AcWindowMode.acWindowNormal)

    End Sub

Everything Works Fine 
But i want to Save Current Report file as PDF Format What should i do?

Note: I'm using VB 2008, Office 2007 and i've installed SavetoPDF.exe
Keating Megan replied to Md. Monirul Islam on 10-Oct-12 02:43 AM
Use this data export tool, it can export data from datatable,command,listview to PDF,Excel,word,text,html,xml,csv,dbf etc. it supports VB2008 and it is totally independent. Hope it can help you:
Md. Monirul Islam replied to Keating Megan on 10-Oct-12 03:19 AM
Spire Data Export Tools seems i need to buy this one. Why i'll buy another 3rd party software :S ? Microsoft's SaveAsPDF.exe is free :)). and i don't need to modify while i creating PDF file. MS Access Report Design Good Enough for me. i just want to know how to Export as PDF format from Access Reports Using VB 2008. Thank You.
Keating Megan replied to Md. Monirul Islam on 10-Oct-12 03:22 AM
If you do not want to use a commercial one, you can use a free one, this is free, but I do not know whether can solve your problem, you can give it a try:http://www.e-iceblue.com/Introduce/free-dataexport-component.html