We help IT Professionals succeed at work.

Can you hide the ribbon and keep the Tabs in Access 2010?

J.R. Sitman
J.R. Sitman asked
on
61 Views
Last Modified: 2019-03-10
it is possible to hide the Ribbon and keep the tabs?   I know how to hide the ribbon.  See attached

tabs.png
Comment
Watch Question

Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016

Commented:
Have you tried the small "caret" at the far right of the ribbon, that does what you are describing.

sshot-677.png
sshot-678.png

»bp
J.R. SitmanIT Director

Author

Commented:
I do know that. I was just wondering if there's a way to code it so that users didn't have to do it
Test your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
J.R. SitmanIT Director

Author

Commented:
Put that in the onload event
Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016

Commented:
Right.


»bp
J.R. SitmanIT Director

Author

Commented:
Thanks
EirmanChief Operations Manager
CERTIFIED EXPERT

Commented:
I use this code on a form button to toggle (hide/show) the ribbon and the Objects on the left.
The tabs always remain visible.
You can experiment by 'commenting' out sections of the code.

Private Sub CommandHIDE_Click()
    Static IsHidden As Boolean

    If IsHidden Then
        DoCmd.ShowToolbar "Ribbon", acToolbarYes
        DoCmd.SelectObject acTable, , True
        IsHidden = False
    Else
        DoCmd.ShowToolbar "Ribbon", acToolbarNo
        DoCmd.NavigateTo "acNavigationCategoryObjectType"
        DoCmd.RunCommand acCmdWindowHide
        IsHidden = True
    End If
End Sub

Open in new window

J.R. SitmanIT Director

Author

Commented:
@Bill.   did not work.  The ribbon and tabs are hidden.
Fabrice LambertConsulting
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
I do not recommend enforcing the ribbon's visibility.
Some users like it minimized, some like it maximized.
Thus, your application should not rely on the ribbon's visibility, neither assumes it is minimized or maximized, because there are no way to check the ribbon's state programatically.

If you are speaking about how access object are displayed (tabs or Windows), you can't interract with these programatically either.
J.R. SitmanIT Director

Author

Commented:
Good point
J.R. SitmanIT Director

Author

Commented:
@Bill.  Correction, it did work.   I had to go to the Current Database options and set it to "display document tabs"

Thanks
J.R. SitmanIT Director

Author

Commented:
Thanks
Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016

Commented:
Welcome.


»bp
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.