Solved

How do you hide the Access Ribbon in 2007

Posted on 2012-04-11
9
341 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:J.R. Sitman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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:J.R. Sitman
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 48

Expert Comment

by:Dale Fye
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
 

Author Comment

by:J.R. Sitman
ID: 37837856
You'll have to be more specific.  Exactly where do I run this command?
0
 
LVL 48

Expert Comment

by:Dale Fye
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:J.R. Sitman
ID: 37837972
See atachment.  this is my problem
office.png
0
 
LVL 48

Assisted Solution

by:Dale Fye
Dale Fye 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:J.R. Sitman
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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

630 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