cant enter database....HELP

[Kelly]

Ok, so I think I made really dumb mistake...as I was creating my switchboard,
still in the devlopment stage...I selected some buttons that got rid of my
tool bar and menu on the top...now I can't enter my data base, I just get the
switchboard page...is theer a command or anything to get me around that so I
can fix it...

 

[Alex White MCDBA MCSE]

Hold down the Either Shift button Before double clicking the mdb (make sure
access is not loaded) keep the button down until the database window
appears.

 

[Ofer]

If you want to enter the DB, hold shift key down while opening your DB, or
press F11 after it been open.

 

[Arvin Meyer]

Ok, so I think I made really dumb mistake...as I was creating my switchboard,
still in the devlopment stage...I selected some buttons that got rid of my
tool bar and menu on the top...now I can't enter my data base, I just get the
switchboard page...is theer a command or anything to get me around that so I
can fix it...

Go to Modules Click on New and paste the following into it, then save the
module:

Option Compare Database
Option Explicit

Function ShowMenu()
On Error Resume Next
DoCmd.ShowToolBar "Menu Bar", acToolbarYes
End Function

Function HideMenu()
On Error Resume Next
DoCmd.ShowToolBar "Menu Bar", acToolbarNo
End Function

Function ShowToolBar()
On Error Resume Next
DoCmd.ShowToolBar "Form View", acToolbarYes
End Function

Function HideToolBar()
On Error Resume Next
DoCmd.ShowToolBar "Form View", acToolbarNo
End Function

'-----------
' End code

Now create a new form with 4 buttons. In the property sheet's click event of
the first one put:

=ShowMenu()

etc. for the other buttons.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Kelly]

Thank you, Thank you... I thought I would have to recreate the
database...what a cool little trick... that is one that I definately need to
keep on hand.... I fixed now to the way I want it....

 

[adsl]

Ok, so I think I made really dumb mistake...as I was creating my
switchboard,
still in the devlopment stage...I selected some buttons that got rid of my
tool bar and menu on the top...now I can't enter my data base, I just get
the
switchboard page...is theer a command or anything to get me around that so
I
can fix it...

 

[adsl]

Hold down the Either Shift button Before double clicking the mdb (make
sure access is not loaded) keep the button down until the database window
appears.



--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

 

[adsl]

Thank you, Thank you... I thought I would have to recreate the
database...what a cool little trick... that is one that I definately need
to
keep on hand.... I fixed now to the way I want it....

 

[adsl]

Go to Modules Click on New and paste the following into it, then save the
module:

Option Compare Database
Option Explicit

Function ShowMenu()
On Error Resume Next
DoCmd.ShowToolBar "Menu Bar", acToolbarYes
End Function

Function HideMenu()
On Error Resume Next
DoCmd.ShowToolBar "Menu Bar", acToolbarNo
End Function

Function ShowToolBar()
On Error Resume Next
DoCmd.ShowToolBar "Form View", acToolbarYes
End Function

Function HideToolBar()
On Error Resume Next
DoCmd.ShowToolBar "Form View", acToolbarNo
End Function

'-----------
' End code

Now create a new form with 4 buttons. In the property sheet's click event
of
the first one put:

=ShowMenu()

etc. for the other buttons.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[adsl]

If you want to enter the DB, hold shift key down while opening your DB, or
press F11 after it been open.