[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