By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,828 Members | 1,862 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,828 IT Pros & Developers. It's quick & easy.

Hiding Access Main Form/tables/queries/forms/etc - Access 97

P: n/a
Thank you in advance for any and all assistance.

Is there a way to hide the Main Access window with tables, queries, forms
etc programmatically?

Michael
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Sat, 17 Jan 2004 17:17:16 -0600, "PMBragg" <pm*****@megavision.com>
wrote:
Thank you in advance for any and all assistance.

Is there a way to hide the Main Access window with tables, queries, forms
etc programmatically?

Yes. Take a look here for some API code that will manipulate the
Access window.

http://www.mvps.org/access/api/api0019.htm

- Jim
Nov 12 '05 #2

P: n/a
On Sun, 18 Jan 2004 03:55:37 GMT, Ji****@NOTdatacentricsolutions.com
(Jim Allensworth) wrote:
On Sat, 17 Jan 2004 17:17:16 -0600, "PMBragg" <pm*****@megavision.com>
wrote:
Thank you in advance for any and all assistance.

Is there a way to hide the Main Access window with tables, queries, forms
etc programmatically?

Yes. Take a look here for some API code that will manipulate the
Access window.

http://www.mvps.org/access/api/api0019.htm

Or, if it is just the database window you want to hide, this was
posted by John Mishefske...

Public Sub hideDBwindow()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub

Public Sub showDBwindow()
DoCmd.SelectObject acTable, , True
End Sub

- Jim
Nov 12 '05 #3

P: n/a
Another way, with probably less control than the programmatic method(s):
With the focus on the database window, click Tools - Startup. Uncheck the
box "Display Database Window". It will be hidden when the database opens.
Can be made visible via Window - Unhide.

To open with the database window visible (and all other non-default startup
options ignored), hold down the Shift key while opening the database via any
usual method.

Bruce Pick

"PMBragg" <pm*****@megavision.com> wrote in message
news:Zn******************@news.uswest.net...
Thank you in advance for any and all assistance.

Is there a way to hide the Main Access window with tables, queries, forms
etc programmatically?

Michael

Nov 12 '05 #4

P: n/a
On Sun, 18 Jan 2004 03:55:37 GMT, Ji****@NOTdatacentricsolutions.com
(Jim Allensworth) wrote:
On Sat, 17 Jan 2004 17:17:16 -0600, "PMBragg" <pm*****@megavision.com>
wrote:
Thank you in advance for any and all assistance.

Is there a way to hide the Main Access window with tables, queries, forms
etc programmatically?

Yes. Take a look here for some API code that will manipulate the
Access window.

http://www.mvps.org/access/api/api0019.htm


I suspect Jim misunderstood your request. It appears you're asking
how to hide the DATABASE Command window on the Access desktop. If so,
just call this procedure from the close event of your title form (or
any other appropriate place in your app:

Public Sub HideDBwindow()
On Error GoTo HandleErr

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

ExitHere:
Exit Sub

HandleErr:
Select Case Err.Number
Case Else
MsgBox "Error " & Err.Number & ": " & Err.Description,
vbCritical, "basLMS.HideDBwindow"
End Select
End Sub

Nov 12 '05 #5

P: n/a
To open with the database window visible (and all other non-default startup options ignored), hold down the Shift key while opening the database via any usual method.


Or press F11 after the database has been opened
Nov 12 '05 #6

P: n/a
On Sun, 18 Jan 2004 11:50:50 +0000 (UTC), "Alan Paterson"
<al*******************@btopenworld.com> wrote:
To open with the database window visible (and all other non-default

startup
options ignored), hold down the Shift key while opening the database via

any
usual method.


Or press F11 after the database has been opened


I have proven this does not always work - especially when you run an
A2K app on A3K (which ought to be called a bug). As far as I can
tell, coding in the close event of your title screen is the only way
to ensure that the DB window is not available to the user.
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.