[AccessD] A2K What's the Opposite F11?

Thanks Charlotte, this one is going in my framework.

Set up an autoexec macro for Ctl-F11 to call this function and you now have
a "hot key" that hides the database window.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Friday, December 19, 2003 11:26 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] A2K What's the Opposite F11?


Are you trying to make sure it's hidden even when someone pressed F11,
or are you just looking for a technique to hide it again when you want
to?  The ultimate way to make sure it stays hidden is to distribute a
runtime version of the application.  There is NO access to the database
window.  If you just want to hide it again for your own use, here's a
routine that will do it.

Public Function HideDBWindow()
  On Error GoTo HideDBWindow_err
  ' select a tab in the Database Window
  DoCmd.SelectObject acTable, , True
  ' Hide the database window
  DoCmd.RunCommand acCmdWindowHide
HideDBWindow_exit:
  Exit Function
HideDBWindow_err:
  MsgBox Err.Description & " (#" & Err & ")"
  Resume HideDBWindow_exit
End Function

Charlotte Foust

-----Original Message-----
From: Darren DICK [mailto:d.dick at uws.edu.au]
Sent: Thursday, December 18, 2003 6:24 PM
To: AccessD List
Subject: [AccessD] A2K What's the Opposite F11?


Hello all
When the dB window is hidden - pressing F11 will make it visible What do
I do to make it IN-visible once it is visible?

EG ALT  F11 toggles the VBE window visible or not is there something
similar that I can toggle the dB Window??

MTIA

Darren

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com