Darren DICK
d.dick at uws.edu.au
Sun Dec 21 17:54:15 CST 2003
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