"Hide" the database window

  • Thread starter Thread starter Duncan Edment
  • Start date Start date
D

Duncan Edment

Rather than minising the database window--where users can still maximise it and
see the object etc.--is there a way to hide it, so that it can't be seen?

Duncan
 
There are a variety of ways to do this... The easiest, is under 'Tools',
'Startup', there is a 'Display Database Window' tick box... You can also do
it with macros and code, quite easily... But, using this option, the user
can still push F11 to get the DB window...
 
That option IS currently un-checked. However, the database window still
appears.

What gives?

Duncan
 
That is strange.

All I can think of is to see if there is an AutoExec macro and/or a startup form. Either of these might be selecting an object in
the database container which would have the effect of un-hiding it.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
No AutoExec macro, however I do have my SwitchBoard set to open at StartUp. Is
there any way round this limitation / feature?

Rgds

Duncan

--
"Outside of a dog, a book is man's best friend. Inside of a dog it's too dark
to read."
~ Groucho Marx

M.L. Sco Scofield said:
That is strange.

All I can think of is to see if there is an AutoExec macro and/or a startup
Click to expand...
form. Either of these might be selecting an object in
 
Dirk,

The database doesn't have an application icon, nor is the "Windows In Taskbar"
option on. I do however, as mentioned in my reply another post, have my
switchboard set as my startup form. Does this mean I can't have the startup
form AND a hidden database window?

I have installed SP1 & SP2 for Office XP.

Regards

Duncan
 
Duncan Edment said:
Dirk,

The database doesn't have an application icon, nor is the "Windows In
Taskbar" option on. I do however, as mentioned in my reply another
post, have my switchboard set as my startup form. Does this mean I
can't have the startup form AND a hidden database window?

I have installed SP1 & SP2 for Office XP.
Click to expand...

Sure you can. HOWEVER, I seem to recall that the Access-generated
switchboard form has a line of code in it to minimize the database
window. Look for such code in the form's Open event procedure. If you
find it, comment it out and save the form. Then exit the database, go
back in, and see what happens.
 
Dirk,

This is interesting. I never ran into this because I hate the Windows in Taskbar option and I turn it off the second I start a new
copy of Access.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Dear Duncan:

This is just a long shot, but once I spent a long time trying to close the
"database window", and it didn't seem to work. This was because I was
confused about the correct terminology. What I *really* wanted to do was
hide the Access Application window (i.e. so that the user would never see
Access, just my forms.) I mistakenly confused the "database window" (the
window in Access which lists the tables/forms, etc.) with the Application
window (the main Access window within which the "database window" is
displayed.

This is probably not the issue, but, what the heck... electrons are cheap!

Good luck!
Fred Boer
 
Yep.

Look for the statement starting with:

DoCmd.SelectObject ...

Not sure whether it is in the Open Event Procedure or not but it is
somewhere in the code for the Switchboard Form.

HTH
Van T. Dinh
MVP (Access)
 
Duncan,

What did you find?

I made new switchboards in Acc97, 2000, and 2003. In all cases I found a comment in the Form_Open event but the code was no longer
there.

Did this database start life in a version before 97 and was converted forward?

Just wondering for future reference.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Sco,

All I did, was use the "Switchboard Manager" within Access 2002 to create a
default switchboard.

Rgds

Duncan

--
"You'll never make it--four-groups are out."
~ Anonymous record company executive, said to the Beatles, 1962

M.L. Sco Scofield said:
Duncan,

What did you find?

I made new switchboards in Acc97, 2000, and 2003. In all cases I found a
Click to expand...
comment in the Form_Open event but the code was no longer
 
The easiest way to hide and protect your application details is to compile
it to an '.mde' file. First, split your application into front end/backend.
The back end contains all the tables except the switchboard items table. The
front end contains everything else including the switchboard items table.
Then you compile and distribute the 'mde' front end for general use. You
MUST keep a copy of the original 'mde' file to enable further development
later. Users of the 'mde' form of the application will be able to use all
the forms, reports etc. but will not be able to see or edit any of the
application details.
Hugh
 
When all else fails...

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Rather than minising the database window--where users can still maximise it
and
see the object etc.--is there a way to hide it, so that it can't be seen?

Duncan
Click to expand...

SHUT THE **** UP YOU STUPID MUTHA ****A! YOU NEED A GIRLFREIND BECAUSE YOU
ARE A ****ING HOMO! **** YOU ALL IF YOU AINT DOWN WIT DA CLOWN!
 
There is an option under tools called "Setup" - on the left hand side there
is a checkbox for "Display Database Window". It defaults to Checked - but
you can change that.

WARNING: Once it is set - it will always hide the database window - so to
Override that hold down the "Shift" key while selecting the MDB/MDE in
Explorer - or in Access during File/Open.

Good Luck!

Yvonne Buffington
 
Back
Top