How to Print MS Access Report

Home » MS Office » How to Print MS Access Report

Posted on January 5, 2009

'MS Office - How to Print MS Access Report

'Add a Command Button to your form and set reference to Microsoft Access xx.x Object Library

Private Sub Command1_Click()
    Dim Ac As Access.Application
    Set Ac = New Access.Application
    Ac.OpenCurrentDatabase ("C:\Temp\Test.mdb")
    Ac.DoCmd.OpenReport "Catalog", acViewNormal
    Ac.CloseCurrentDatabase
End Sub