Access 2010 Ribbons - Trying to understant the facts

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  It has two ribbons in USysRibbons table and on Options / Ribbon Name = one of the ribbons (AppRibbon)
Access 2010 Current db Options
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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 ...


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LJGAuthor Commented:
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?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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 ...

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.