Hiding access window in Access 2003

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

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
 
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
 
Jasper Recto said:
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?
Click to expand...


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.
 
Back
Top