[AccessD] A2K What's the Opposite F11?

Thanks to all who responded
Thanks so much for the code Charlotte

In my app the db window is 'hidden'
However, when I run a word merge routine it makes the window 'visible'
It is doing this because I am making queries for merging on the fly. And of course
it 'talks back' to the db window, making it visible again. - I 'spose
Charlottes code is excellent, because I can then make the window hidden as soon as it becomes visible again
I don't have the time to really track this down. Charlottes code will go in the line after I start the word merge:-))

Thanks Charlotte et al

Darren

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Saturday, December 20, 2003 3:26 AM
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