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)
appAccess.DoCmd.PrintOut()
appAccess.Quit()

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:
http://www.e-iceblue.com/Introduce/data-export-for-net-intro.html

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