[AccessD] Programmatically Hide the DATABASE Window

Paul Rodgers Paul.Rogers at SummitMedia.co.uk
Tue Aug 3 02:56:07 CDT 2004


Darren

That is good ... but how can I hide Window/Unhide? 

I suppose I could put Charlotte's public function in another db and trigger
from there?

Sorry, so many questions to begin (or end) your day. Hope the winter's ok
there. 

Cheers paul 

-----Original Message-----
From: Darren DICK [mailto:d.dick at uws.edu.au]
Sent: Monday, August 02, 2004 11:12 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Programmatically Hide the DATABASE Window


Hi Paul
In Charlotte's code below replace 

DoCmd.RunCommand acCmdWindowhide
with
DoCmd.RunCommand acCmdWindowUnhide

----- Original Message ----- 
From: "Paul Rodgers" <Paul.Rogers at summitmedia.co.uk>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Monday, August 02, 2004 5:51 PM
Subject: RE: [AccessD] Programmatically Hide the DATABASE Window


> Interesting, Charlotte, but what happens when you want to Unhide so you
can
> work on the  database?
> 
> I always use the StartUp checkboxes myself - but then I am usually always
> around when the databases are being used. 
> 
> I can see it there are many times when it would be useful to have only the
> required form showing, and Unhide unavailable too. So I will await keenly
> for an answer. All the best
> 
> paul 
> 
> -----Original Message-----
> From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
> Sent: Friday, July 30, 2004 7:09 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Programmatically Hide the DATABASE Window
> 
> 
> Try this:
> 
> 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: Greg Smith [mailto:GregSmith at starband.net] 
> Sent: Friday, July 30, 2004 9:46 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Programmatically Hide the DATABASE Window
> 
> 
> Hello everyone, again.  It's FRIDAY!
> 
> Pretty much got the menu bar working (one issue with the "menu Bar"'s
> control box not showing up after being disabled then enabled...but
> that's not the point here).
> 
> I want to hide the main database window (the one with the queries,
> tables, forms, etc., to be exact) on startup, but not using the
> Startup's checkbox, but through vb.  The DBA Archives dance around the
> issue, but I can't find where it's addressed.  Is there a way to do this
> through code or am I stuck with using the checkbox in the Startup menu?
> I'm using Access97 in this app.
> 
> Thanks!
> 
> Greg Smith
> gregsmith at starband.net
> 
> 
> -- 
> _______________________________________________
> 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
> 
> -- 
> _______________________________________________
> 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




More information about the AccessD mailing list