Access automation, view single object

[DaveBo]

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

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

[RhinoBull]

Her is a quick sample:

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

[DaveBo]

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.

[DaveBo]

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

[Dave Sell]

Um I spose you tried this:

accFrm.Visible = False

[DaveBo]

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

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.

[Dave Sell]

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.

[DaveBo]

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

[Dave Sell]

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