[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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