Results 1 to 5 of 5

Thread: Ribbons

  1. #1
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267

    Unanswered: Ribbons

    To All--

    I know how to load custom Ribbons in Access 2013. The problem is...how can I load the "default" (Home, Create, etc tabs) Ribbon back during runtime?

    Thanks.

    C

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I never do this sort of thing, but just came across this, today, elsewhere

    DoCmd.ShowToolbar "Ribbon", acToolbarYes

    You may have to hide the custom one, if you don't want it

    DoCmd.ShowToolbar "YourRibbonName", acToolbarNo

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267
    Thanks for the reply.

    Unfortunately, DoCmd.ShowToolbar "Ribbon", acToolbarYes or acToolbarNo shows or hides the entire Ribbon. I need to just show the standard default Ribbon and not hide it completely.

    Any other thoughts?

    C

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by canupus View Post
    Thanks for the reply.

    Unfortunately, DoCmd.ShowToolbar "Ribbon", acToolbarYes or acToolbarNo shows or hides the entire Ribbon. I need to just show the standard default Ribbon and not hide it completely.
    Then

    DoCmd.ShowToolbar "Ribbon", acToolbarYes

    should work to show it. The

    DoCmd.ShowToolbar "YourRibbonName", acToolbarNo

    referred to hiding your custom ribbon (hence the name YourRibbonName that was used) when you revealed the native ribbon...or am I misunderstanding you completely?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267
    I create a custom Ribbon using XML and the USysRibbons table - I name the Ribbon "Main". Using Options-->Current Database I set the Ribbon name to "Main".

    DoCmd.ShowToolbar "Main", acToolbarNo does not work. In fact it throws the error that it can't find the Toolbar.

    I guess I'm confusing Toolbars and Ribbons in Access 2013. I'm now using CallBack functions for the Ribbon I created to manipulate which groups or tabs are shown by using .Invalidate of the Ribbon control to refresh and check the Visible property.

    Thanks.

    C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •