i need to open a report that i created in access 97 from a VB6 program and i need help,i need the code that will open a specific report in an mdb file .
10x
Printable View
i need to open a report that i created in access 97 from a VB6 program and i need help,i need the code that will open a specific report in an mdb file .
10x
Private Sub Command1_Click()
Dim a As Access.Application
Set a = CreateObject("Access.Application")
a.OpenCurrentDatabase App.Path & "\NWind.mdb"
a.Visible = True
a.DoCmd.OpenReport "Catalog", acViewPreview
a.DoCmd.Maximize
End Sub
That should do it for ya