Hiding/Showing database window from VBA

  • Thread starter Thread starter Jeff Kowalczyk
  • Start date Start date
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.
 
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?
Click to expand...

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.
 
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.
Click to expand...

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