Access 2010 Ribbons - Trying to understant the facts

Posted on 2013-10-11
Medium Priority
Last Modified: 2013-10-14
Version -->2010

You only want to see a Ribbon when previewing a report (with appropriate buttons)
You have the appropriate buttons etc on a ribbon in USysRibbons called --> PrintPreview

It would appear to me, you do not need to put a Ribbon name in --> Options / Ribbon Name, if you use some simple code (see below)?  See graphic below.

Am I misunderstanding something in the Simple Code below?

Simple Code
On Opening form - All Ribbons including QAT go away with the following code.
      DoCmd.ShowToolbar "Ribbon", acToolbarNo

On Report
   * Property Sheet -->Other tab / Ribbon Name / PrintPreview<-- Ribbon Name from table

   * On Load
        DoCmd.ShowToolbar "Ribbon", acToolbarYes      

      * On Close  
         DoCmd.ShowToolbar "Ribbon", acToolbarNo

Giving Credit where Credit is Due
I'm learning the Ribbon process and at this point just trying to get an understanding of how it all works.   I downloaded a simple database (DB31_EN.accdb) from Gunter Avenius site http://www.accessribbon.de/en.  It has two ribbons in USysRibbons table and on Options / Ribbon Name = one of the ribbons (AppRibbon)
Access 2010 Current db Options
Question by:LJG
  • 2
LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 2000 total points
ID: 39567040
In Gunter's db, the AppRibbon (and in Options) is what will display when Access loads,

Set the Report's Ribbon Name property to "PrintPreview'.
When you open the Report, that Ribbon will display.
When you close it, the App Ribbon will display again.

That's  pretty much it ...


Author Comment

ID: 39567103
Thanks DatabaseMX

But - My question is - I don't see a need to load App Ribbon at startup.  Is there some need?

If on the Opening form - Event --> Form Load  
      DoCmd.ShowToolbar "Ribbon", acToolbarNo

--> Then All Ribbons including QAT go away / Including in this example --> AppRibbon goes away.

Also do you agree that my understanding or what happens with the simple code, in the original post, is correct?
LVL 75
ID: 39567119
Well,  if you are not wanting any Ribbon to show when Form opens, the I suppose you can do this. Did you try it ?
And if so, when you open the Report does the PrintPreview ribbon show (assuming you have the Ribbon Name property set to PrintPreview) ?

I don't think there is any right or wrong here, just what works best for your case ...


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

627 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