[RESOLVED] Microsoft Access Hide Main Window
Using 2000 Microsoft Acces:
not sure if this the best place for Access questions but since Access uses VBA I figure it's close enough :)
[Hide Main Form:]
Any other info on on to permantly or when the the Program loads to hide the Main Tables screen
I hid it using the Window option to hide the selected Form but when the program loads again it reopens.
[Unhide regular Form:]
Also I had accidently permantly hid a form I hightlighted the Form name under the toolbar View went to properties and under attribute I checked hidden thinking it was the main form, which it wasn't...
in the Design Main Form where it lists all the forms, Queries, etc this file is not shown but I am able to run it when my program calls it.
:wave:
Thank you in advance,
Any help would be appreciated
Re: Microsoft Access Hide Main Window
VB Code:
Private Sub cmdUnlock_Click()
'SetAllowByPassKey True
DoCmd.SelectObject acTable, , True
End Sub
Private Sub cmdLock_Click()
'SetAllowByPassKey False
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub
That just hides/unhides the main db window, is that what you're after?
Re: Microsoft Access Hide Main Window
Yes the following code works great.
VB Code:
Private Sub cmdUnlock_Click()
'SetAllowByPassKey True
DoCmd.SelectObject acTable, , True
End Sub
Private Sub cmdLock_Click()
'SetAllowByPassKey False
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub
Any idea about the second question
Quote:
[Unhide regular Form:]
Also I had accidently hid a form I hightlighted the Form name under View > properties > attribute I checked hidden thinking it was the main form, which it wasn't... :D
in the Design Main Form where it lists all the forms, Queries, etc this file is not shown but I am able to run it when my program calls it.
I could still get to the hidden Form and clicking the Design button but I wonder if there is any way to get the form to display back on the Main Form.
In the Main Window the form name was highlighted
View > Properties then
checked the Hidden checkbox under Attributes
just something that I accidently did and am wondering if you know of anyway to bring the form back to unhidden. The form still opens when the programs run but in the main Window it is hidden
Thanks for your helo :duck:
Re: Microsoft Access Hide Main Window
In The Tools Options Menu of a database there is an tab called "View" on here you can choose whether or not to display hidden items.
Re: Microsoft Access Hide Main Window
Thanks for your help.. I made sure to rate you guys Thanks again