Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

How do you hide the Access Ribbon in 2007

When I make the mde in Access 2007 the users can see the ribbon.  How do I prevent this?
0
J.R. Sitman
Asked:
J.R. Sitman
2 Solutions
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Are you creating the MDE with Access 2007 or a prior version of Access?
0
 
J.R. SitmanAuthor Commented:
I did what it said in the article now I no longer have any options excpet "close access" in the Office Button.  How do I get the options back?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Dale FyeCommented:
I use a subroutine, that I can call from the immediate window or via code:

to hide the ribbon:

DisplayRibbon False

to reveal the ribbon:

DisplayRibbon

Public Sub DisplayRibbon(Optional IsVisible As Boolean = True)

    If Application.Version < 12 Then
        'do nothing
    Else
        DoCmd.ShowToolbar "Ribbon", IIf(IsVisible, acToolbarYes, acToolbarNo)
    End If
   
End Sub
0
 
J.R. SitmanAuthor Commented:
You'll have to be more specific.  Exactly where do I run this command?
0
 
Dale FyeCommented:
I put it in the Open event of my Startup form when I'm ready to field my application.

When I'm working on it, I remark that line out so that it stays visible while I'm creating the application.  If I want to see what the form look like without the ribbon displayed, I simply type the command in the VBA debug/immediate window
0
 
J.R. SitmanAuthor Commented:
See atachment.  this is my problem
office.png
0
 
Dale FyeCommented:
I'm not familiar with the technique mentioned by @kinecsys in the original response to your post, so I don't know how to whatever action you took to get to your current situation.

Have you tried holding down the Shift key, when you open your database?  This will generally bypass all startup settings and get you a clean database.  Then you should be able to go to the Office button, and reverse the actions you took relating to that article.

1. Click the Microsoft Office Button Button image and then click Access Options.
2. Click the Current Database option and then, in the Ribbon and Toolbar Options section, click the Ribbon Name list and select HideTheRibbon.  ( I think you would UNSELECT 'Hide the Ribbon'), but since I don't see this option, am not 100% certain.
3. Close and restart the application.
0
 
J.R. SitmanAuthor Commented:
the first post answered my question, but the last post saved my butt.  I don't recommend anyone use the first post.

Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now