Avatar of J.R. Sitman
J.R. SitmanFlag for United States of America asked on

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

it is possible to hide the Ribbon and keep the tabs?   I know how to hide the ribbon.  See attached

tabs.png
Microsoft Access

Avatar of undefined
Last Comment
Bill Prew

8/22/2022 - Mon
Bill Prew

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
ASKER
J.R. Sitman

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
ASKER CERTIFIED SOLUTION
Bill Prew

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
J.R. Sitman

Put that in the onload event
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Bill Prew

Right.


»bp
ASKER
J.R. Sitman

Thanks
Eirman

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

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
J.R. Sitman

@Bill.   did not work.  The ribbon and tabs are hidden.
Fabrice Lambert

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.
ASKER
J.R. Sitman

Good point
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
J.R. Sitman

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

Thanks
ASKER
J.R. Sitman

Thanks
Bill Prew

Welcome.


»bp
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.