Access automation, view single object

I'm currently able to open an Access MDB file's objects (reports, tables, forms, etc) from a VB app, but the full-blown MDB comes up also.

Is it possible to just open/view a single object, e.g. one report, without exposing the whole Access app?

Here's what I'm doing now

VB Code:

Dim accApp as Access.Application
       :
    Set accApp = New Access.Application
 
    accApp.OpenCurrentDatabase (MDB_Path)
    accApp.Visible = True
    accApp.RunCommand acCmdAppMaximize
 
    accApp.DoCmd.OpenReport "my_report", acViewPreview
    Set accApp = Nothing

Feel free to make any constructive criticisms/suggestions.

Thanks, DaveBo

Her is a quick sample:

VB Code:

Public Sub RunAccessReport(strDB As String, strReport As String, _
                           Optional strFilter As String = "", _
                           Optional strWhere As String = "")
'===================================================================
Dim AccessDB As Access.Application
 
    Set AccessDB = New Access.Application
    AccessDB.OpenCurrentDatabase strDB
    AccessDB.DoCmd.OpenReport strReport, acViewPreview, strFilter, strWhere
    AccessDB.Visible = True
    Set AccessDB = Nothing
 
End Sub
 
'usage:
Private Sub Command1_Click()
    RunAccessReport App.Path & "\nwind.mdb", "Catalog"
End Sub

Thanks RhinoBull, but that's what I'm doing now.

What I'm trying to avoid is having Access bring up the entire MDB,
i.e. I just want to see the report and not the database window, switchboard etc.

Is it possible to declare an Access form object, e.g.
Dim accFrm As Access.Form

then open the DB as above but without setting it visible,
and then setting accFrm to a specific form in the Access DB
and then just setting accFrm.Visible = True
to just display that form?

Thanks, DaveBo

Um I spose you tried this:

VB Code:

accFrm.Visible = False

Quote:

---

Originally posted by Dave Sell
Um I spose you tried this:

VB Code:

accFrm.Visible = False

---

It's just the one form that I want to make visible.
i.e. keep the Access environment hidden if it has to be running at all.

OK I see what youmean now. You want to have only a child MDI Form of a parent MDI Form be visible without the parent being visible?

I don't think Windows can handle this.

Dave, That's what I was missing here, that Access is an MDI app.
and all those other objects are MDI child forms!

Back to the drawing board.
Can an Access form be imported into a VB app?

Thanks, DaveBo

Ya, I would ask this as a new thread in the general VB6 programming thread and mark this one resolved.