Improve company productivity with a Business Account.Sign Up

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

Access 2007 Ribbon Hide Tab

Hi,

Is it possible to hide a tab on a user ribbon depending on the form that's used.  When I switch from one form to another I would like different options.

Thanks,

Bill
0
Bill Ross
Asked:
Bill Ross
  • 3
  • 2
2 Solutions
 
Gustav BrockCIOCommented:
You can use Albert Kallal's ribbon class to hide/show objects of the ribbon:

http://kallal.ca/Ribbon/ribbon.htm

Or you can set different ribbons for different forms.

/gustav
0
 
Bill RossAuthor Commented:
Thanks gustav, I'm looking at that now.

Along those same lines is there a way to activate a tab on the ribbon when a form is activated?
0
 
Gustav BrockCIOCommented:
You don't need the class of Kallal.
Here's an example for setting a tab in a simple setup:

http://www.access-programmers.co.uk/forums/showthread.php?t=246015

/gustav
0
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'.

 
BitsqueezerCommented:
Hi,

one possible method is of course the use of getVisible - but another more simple one is that you create a specialized ribbon and simply assign it directly to the form by using the property "RibbonName" of the form.
Whenever you open the form, Access automatically insert the tab as the last one (can also contain more than one tab, then all of them).
This method has the advantage that also the title bar of Access will be separated and the form title and a separator is inserted. You can see the effect if you open a form in design mode: Two further tabs will be added to the ribbon with the separator and title into the Access title bar. If you close the form, both will be removed.

I recommend this site to learn anything about ribbons, includes some tools:

http://www.accessribbon.de/en/

Cheers,

Christian
0
 
Bill RossAuthor Commented:
Thanks for the help.  Got it!
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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