[AccessD] Programmatically Hide the DATABASE Window

Charlotte Foust cfoust at infostatsystems.com
Wed Aug 4 11:00:26 CDT 2004


It's perfectly possible to turn off those features unless a command-line
argument is passed when the database is open.  I've done that on
projects in order to leave myself a backdoor but remove any way for the
user to get into the guts of the mdb.  

Charlotte Foust


-----Original Message-----
From: Paul Rodgers [mailto:Paul.Rogers at SummitMedia.co.uk] 
Sent: Tuesday, August 03, 2004 11:38 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Programmatically Hide the DATABASE Window


Hi Charlotte

It would be ideal if upon opening their Access database there was just a
form that offered all the Users could need. I'd like them not to be
going to tables and queries - and nor to be able to find how to get
there.

When you offered that neat piece of coding before, you reminded me of
what I see as ideal. Of course one can make adjustmentments on Startup.
But they quickly learn the Window/Unhide entrance. 

All the best
paul 

-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Tuesday, August 03, 2004 5:04 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Programmatically Hide the DATABASE Window


Sorry, but I don't see how the user could use an app where they saw a
form and nothing else.  It is possible to float a form by shrinking and
hiding the *main* Access window behind it, but it frankly isn't worth
the trouble IMO.

Charlotte Foust


-----Original Message-----
From: Paul Rodgers [mailto:Paul.Rogers at SummitMedia.co.uk] 
Sent: Tuesday, August 03, 2004 7:51 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Programmatically Hide the DATABASE Window


Hi Charlotte

I'm using your code and it works well, thank you.

But, yes, I am trying to achieve something else, as you say. I want to
give the user a form and nothing else - but I need to be able to go in
and out myself to make adjustments et al. Is this something you could
advise on please?

Cheers paul


-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Tuesday, August 03, 2004 4:36 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Programmatically Hide the DATABASE Window


I don't quite understand what you're trying to do.  The database window
is only visible from within the application, so you put the code into
public functions and create an autokey to trigger it, if that's what
you're trying to accomplish.  If you're talking about hiding something
else, like the main window, that's an entirely different thing. 

Charlotte Foust


-----Original Message-----
From: Paul Rodgers [mailto:Paul.Rogers at SummitMedia.co.uk] 
Sent: Monday, August 02, 2004 11:56 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Programmatically Hide the DATABASE Window


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

-- 
_______________________________________________
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

-- 
_______________________________________________
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