Hiding/Showing database window from VBA

J

Jeff Kowalczyk

I have an end-user Access 2002 database using a form front-end to launch
query datasheets and reports. The startup option to hide the database
project window* is ideal for removing this complexity from users who
don't need it. Security is not the objective, just hiding of unneeded
windows.

However, as the maintainer of the database, I often need to jump in and
add new queries, adjust code in the VBA module, etc. Changing the startup
option and reopening the database to access the startup window is
inconvenient.

Is there a VBA option to show and hide the database project window in
projects which have been opened with the startup option to hide the
database window?

Alternatively, is there a VBA method I could call when the front-end form
loads to hide the database project window?

Thanks.

* The database project window refers to the Access database window which
provides an explorer to tables, queries, forms, reports, modules, etc.
 
J

Jeff Kowalczyk

Is there a VBA option to show and hide the database project window in
projects which have been opened with the startup option to hide the
database window?
Alternatively, is there a VBA method I could call when the front-end form
loads to hide the database project window?

I did find that the database project window hidden with the startup
option can be brought back from Window | Unhide... menu command, and that
the window will still be hidden when the database is next opened, which is
the preferred behaviour. Is this unhide/hide toggle reachable from VBA
code?

Thanks.
 
D

Dirk Goldgar

Jeff Kowalczyk said:
I have an end-user Access 2002 database using a form front-end to
launch query datasheets and reports. The startup option to hide the
database project window* is ideal for removing this complexity from
users who don't need it. Security is not the objective, just hiding
of unneeded windows.

However, as the maintainer of the database, I often need to jump in
and add new queries, adjust code in the VBA module, etc. Changing the
startup option and reopening the database to access the startup
window is inconvenient.

Is there a VBA option to show and hide the database project window in
projects which have been opened with the startup option to hide the
database window?

Alternatively, is there a VBA method I could call when the front-end
form loads to hide the database project window?

Thanks.

* The database project window refers to the Access database window
which provides an explorer to tables, queries, forms, reports,
modules, etc.

It's quite easy. The answer is on The Access Web:

http://www.mvps.org/access/general/gen0031.htm
Show/Hide database window from code
 

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

Top