Hiding access window in Access 2003

[Jasper Recto]

I have a little Access application than automatically opens up a form when
launched.

It also opens up the whole access window with the menu bar and everything.
Is there a way to prevent the access window from showing? All I want to
show are the forms and reports by themselves.

Any suggestions?

Thanks,
Jasper

 

[Scout06]

There are some options under "Tools" then Startup, for the tool bars that
allow access to the tables, etc.

other option is under "Tools" Database Utilities, then Switchboard Manager

 

[Dirk Goldgar]

I have a little Access application than automatically opens up a form when
launched.

It also opens up the whole access window with the menu bar and everything.
Is there a way to prevent the access window from showing? All I want to
show are the forms and reports by themselves.

Any suggestions?

I don't suppose you tried searching for something like "Access hide
application window"? <g> See this link (second returned when I google for
those terms):

http://mvps.org/access/api/api0019.htm
API: Manipulate Access Window

Note 1: in recent versions of Access, the form to be displayed must be have
both its PopUp *and* Modal properties set to True.

Note 2: In some versions of Access, the timing is such that you have to
force the form to be visible before hiding the application window:

Private Sub Form_Open(Cancel As Integer)
Me.Visible = True
DoEvents
fSetAccessWindow SW_HIDE
End Sub

Note 3: Because of note 1, this really only works when your application only
needs one form open at a time.

Note 4: Previewing reports is a pain when you do this. I seem to recall
figuring out how to do this at one point, but it was tricky, and I can't
remember now what I did. It probably involved making calls to Windows API
functions.