Hiding the Access Shell

Tim Conrad

unread,

Oct 29, 2001, 4:45:03 PM10/29/01

to

Is it possible to write code so that the shell of access is invisible.
Allowing only the selected form to be shown on the desktop. I have found
code that let's me set the form to a popup and it will float on the outside
of the shell but if I minimize access the form disappears. I would like to
make the shell disappear completely if possible.

Thanks

Tim Conrad

Al Borges

unread,

Oct 30, 2001, 5:25:00 AM10/30/01

to

Hi Tim:

I've ransacked my extensive bookshelf of Access '97 and 2000 books and
came out blank. One source in particular buried the idea of hiding the
Access Shell- if you look at Microsoft Access 2000 Bible, in chapter 4, they
spend a good deal of time discussing how one can change "The Access Window"
(title of subchapter), and on summary discusses "Options That Change How
Access Looks". You can change/get rid of the title bar, the toolbar, you can
maximize, you can minimize, etc etc. You can't hide it, though, while
leaving the database window intact. Sorry.

Regards,

Al Borges

"Tim Conrad" <tim_bren...@msn.com> wrote in message
news:ekZJqKMYBHA.1408@tkmsftngp05...

Terry Kreft

unread,

Oct 30, 2001, 4:34:47 AM10/30/01

to

Go to
http://www.mvps.org/access/api/api0019.htm

"Tim Conrad" <tim_bren...@msn.com> wrote in message
news:ekZJqKMYBHA.1408@tkmsftngp05...

Tim Conrad

unread,

Oct 30, 2001, 9:24:46 AM10/30/01

to

Thanks Terry, I had already checked that resource and came up with two
examples there, the one you referenced being one of them. It will allow me
to hide, minimize, maximize ect. however it doesn't allow me to work with my
forms and have the Access Shell hidden. Unless you know something that I am
missing. When I call the hide my forms vanish as well.

Al, thanks. I too checked all my books and came up empty. Then checked all
my online resources and still empty. So I thought I would put a lot of heads
and knowledge together in one place for help.

Any other suggestions would be appreciated. I am not sure if this can be
done but I would like to try.

Thanks all.
Tim

"Tim Conrad" <tim_bren...@msn.com> wrote in message
news:ekZJqKMYBHA.1408@tkmsftngp05...

Terry Kreft

unread,

Oct 30, 2001, 11:08:48 AM10/30/01

to

Tim,
I wrote the code so I know it works.

If you're using Access2000 the form needs to be modal and pop-up for it to
work.

In A97 it only needs to be pop-up

In A2k2 probably the same as A2000

"Tim Conrad" <tim_bren...@msn.com> wrote in message

news:esI7C$UYBHA.1412@tkmsftngp03...

Tim Conrad

unread,

Oct 30, 2001, 1:17:39 PM10/30/01

to

Terry,
Thanks for the reply I guess if you wrote it then you should know that it
works, but I am still having problems. I am using your code with the form
set to modal and pop-up. The Open Event, is calling the fSetAccessWindow
function with SW_HIDE as the argument, but I get a error message that says
"Cannot Hide Access unless a form is on the screen" Any Ideas?
Thanks Tim

"Terry Kreft" <terry...@mps.co.uk> wrote in message
news:O#POC0VYBHA.2104@tkmsftngp05...

Tim Conrad

unread,

Oct 30, 2001, 1:23:02 PM10/30/01

to

Never mind Terry I think I got it. I had to add Me.Setfocus to the form load
event. Now it seems to be working fine. Thanks

Tim
"Terry Kreft" <terry...@mps.co.uk> wrote in message
news:O#POC0VYBHA.2104@tkmsftngp05...

Terry Kreft

unread,

Oct 31, 2001, 4:46:34 AM10/31/01

to

Tim,
Before you call the proc, try putting the line
Me.Visible = True

So bare bones code is

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

If that doesn;t work put
Doevents in between

The open event for the form is a funny beast, it's more like the Initialize
event for a class module, at the time the event is running Access sometimes
acknowledges the form exists and sometimes it doesn't. one way to force the
acknowledgement is to set the visible property to True.

Terry

"Tim Conrad" <tim_bren...@msn.com> wrote in message

news:uy5j5$WYBHA.2104@tkmsftngp05...

Mark Phillipson

unread,

Oct 31, 2001, 5:15:32 AM10/31/01

to

If you force the database to be opened using Access Runtime you will never
see a database window.

(use the /RUNTIME command line option)

For e.g. enter the following in the target of a shortcut:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\Progam\dbname.mdb" /RUNTIME

"Tim Conrad" <tim_bren...@msn.com> wrote in message

news:OzDPTJXYBHA.1556@tkmsftngp03...

Terry Kreft

unread,

Oct 31, 2001, 5:22:06 AM10/31/01

to

Mark,
We're talking about the Application window here (the MDI) not the database
window.

Terry

"Mark Phillipson" <mphil...@mercury-international.com> wrote in message
news:u1lgQVfYBHA.2132@tkmsftngp03...