Access Report

S

shannon

it's a example:

Dim MSAccess As Access.Application

Private sub Command1_Click()
¡¡¡¡Set MSAccess=NEW Access.Application
¡¡¡¡MSAccess.OpenCurrentDatabase(App.Path & "\data.mdb")
¡¡¡¡
¡¡¡¡MSAccess.DoCmd.OpenReport "rptMyData",acViewNormal
¡¡¡¡MSAccess.CloseCurrentDatabase

¡¡¡¡Set MSAccess=Nothing
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top