start access reports or form from vb6

[mukund_Sadrani]

hello any help me to open and run ms access mdb file with access-report and access-form

[choudhuryshouvi]

what exactly are you trying to do?

are you trying to create access forms and reports from your vb6 application?

or,
trying to create forms and reports in access and want to fire those reports from vb6 application?

explain clearly...

[mukund_Sadrani]

i try my old access base application run from my new vb6 base application

[QVeen72]

Hi,

Reference a "Microsoft Access" Object library in your Project and try this code:

Dim MyAcc As New Access.Application
MyAcc.OpenCurrentDatabase "C:\MyDb.mdb" , True

MyAcc.DoCmd.OpenReport "MyReportName", acViewPreview

'Open Form
MyAcc.DoCmd.OpenForm "MyFormname"
'Quit access
MyAcc.Quit
Set MyAcc = Nothing

Regards
Veena

[mukund_Sadrani]

Thanks

[QVeen72]

Hi,

Welcome, Mark the thread as "Solved"

Regards
Veena