Solved

How do you hide the Access Ribbon in 2007

Posted on 2012-04-11
9
335 Views
Last Modified: 2012-04-12
When I make the mde in Access 2007 the users can see the ribbon.  How do I prevent this?
0
Comment
Question by:jrsitman
9 Comments
 
LVL 7

Accepted Solution

by:
kinecsys earned 150 total points
ID: 37835880
0
 
LVL 21
ID: 37835907
Are you creating the MDE with Access 2007 or a prior version of Access?
0
 

Author Comment

by:jrsitman
ID: 37837010
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
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37837482
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:jrsitman
ID: 37837856
You'll have to be more specific.  Exactly where do I run this command?
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37837909
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
 

Author Comment

by:jrsitman
ID: 37837972
See atachment.  this is my problem
office.png
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 100 total points
ID: 37838083
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
 

Author Closing Comment

by:jrsitman
ID: 37841143
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now