[RESOLVED] Microsoft Access Hide Main Window

[Zoila]

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

[demotivater]

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?

[Zoila]

Yes the following code works great.

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


[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:

[dannymking]

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.

[Zoila]

Thanks for your help.. I made sure to rate you guys Thanks again