database window

D

Dave

Hi all,
I've hidden the database window on Startup, disabled the
F11 key and disabled the bypass key. I now need to be able
to access the database window from an Admin form via a
button. Can anyone please provide help on how I could do
this? I've searched through the online help to no avail.
Thanks in advance,
Dave
 
W

Wayne Morgan

RunCommand acCmdWindowUnhide

will bring up the Window Unhide dialog. You can select the database window from here and
unhide it.

Another option is to reset the Hide Database Window option. Doing this will require
closing and reopening the database after the option has been changed before the window
will show. The same thing could be done with the Bypass Keys option with the same
requirement.

CurrentDb.Properties("StartupShowDBWIndow")=True
or
CurrentDb.Properties("AllowSpecialKeys")=True
 
D

Dave

Thanks for that tip Wayne.
The windowunhide method will do the job.
Dave

-----Original Message-----
RunCommand acCmdWindowUnhide

will bring up the Window Unhide dialog. You can select
the database window from here and
unhide it.

Another option is to reset the Hide Database Window
option. Doing this will require
 
D

Dirk Goldgar

Dave said:
Hi all,
I've hidden the database window on Startup, disabled the
F11 key and disabled the bypass key. I now need to be able
to access the database window from an Admin form via a
button. Can anyone please provide help on how I could do
this? I've searched through the online help to no avail.
Thanks in advance,
Dave

How about just using DoCmd.SelectObject to select some object you know
exists, specifying the optional argument to select the object in the
Database Window. Along the lines of:

DoCmd.SelectObject acForm, "frmAdmin", True
 

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