"Hide" the database window

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
 
R

Ruskin Hardie

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...
 
D

Duncan Edment

That option IS currently un-checked. However, the database window still
appears.

What gives?

Duncan
 
M

M.L. Sco Scofield

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
 
D

Duncan Edment

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
 
D

Duncan Edment

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
 
D

Dirk Goldgar

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.
 
M

M.L. Sco Scofield

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
 
F

Fred Boer

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
 
V

Van T. Dinh

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)
 
M

M.L. Sco Scofield

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
 
D

Duncan Edment

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
 
H

Hugh N. Ross

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
 
M

M.L. Sco Scofield

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
 
R

Rory

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 FUCKA! YOU NEED A GIRLFREIND BECAUSE YOU
ARE A FUCKING HOMO! **** YOU ALL IF YOU AINT DOWN WIT DA CLOWN!
 
Y

Yvonneb

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
how to hide the whole database windows 2
Merging from an Excel file with graphics 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Tracked changes by multiple people modified to one 0
DoCmd.Maximize results in Access covering Windows task bar! 5
Hide Access Application window? 9
Possible to Combine reports to's to a single box? 0

Top