VB 6.0 and MS Access

[Nadeem Bhatti]

how i can call MS Access form or report in vb6. i have project in vb and a report in access which i want to call vb6. any one can help . . . . . .

[QVeen72]

Hi,

Open Access Report :

[code=vb]
Dim objAccess As Object
Set objAccess = CreateObject("A ccess.Applicati on")
objAccess.OpenC urrentDatabase "C:\MyDB.md b', False
objAccess.DoCmd .OpenReport strRptName, acPreView, strFilter, _
strWhere
objAccess.Quit acExit
Set objAccess = Nothing
[/code]

To Open Form(All remains Same ):
[code=vb]
objAccess.DoCmd .OpenForm "frmMyForm" , acNormal, , ,
acFormReadOnly, AcWindowMode

[/code]

Regards
Veena