Open report : Report « Access « VBA / Excel / Access / Word






Open report

 
Sub runReport()
    Dim con As ADODB.Connection

     Set con = New ADODB.Connection
    con.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
       "Data Source=C:\mydb.mdb;"

    DoCmd.OpenReport "rptCustomer", acViewPreview

End Sub

 








Related examples in the same category

1.Creating an Empty Report
2.Create a named report
3.Adding Controls to the Report
4.Print preview Report