Results 1 to 6 of 6
  1. #1
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55

    Customize Ribbon

    Hello all,

    I've created a small Access 2016 Database and I want to limit what is seen on the Ribbon.

    I am able to customize the Ribbon via right clicking on the menu and selecting what I want. It works fine but the problem is that any other database that I open or create contains those changes. I just want to change the ribbon for one specific application and not every time I open Access.

    Any ideas?

    Thanks,
    BLD

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The approach will depend on what you do want to show.
    You can hide all ribbon menus except File and Home by disabling Allow Full Menus in Access Options ...Current Database.

    If you want to disable either or both File and Home ...or if you just want to modify ribbon menus, its more tricky. You need to do this using XML in a specially created system table called USysRibbons. Recommend you look at Gunter Avenius' website https://www.ribboncreator2016.de/en/
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55
    Yes I've tried disabling Allow Full Menus which works fine but I need to keep the EXTERNAL ribbon. I only need to see Home and External.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Then you will need to create a USysRibbons table in order to create a custom ribbon.
    Does that mean you want to hide the File menu as well?
    Study the examples on the website I mentioned
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55
    Thank you, I would want to also see the File menu. File/Home/External.

    I am a little hesitant about downloading and using the Ribbon editor.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You don't need to install the Ribbon creator app but it will make the process easier.
    However, you can create the USysRibbons table without using it.
    All you will need is to know the code to show just those three menus.
    If you check the tutorials on that site or do a Google search, someone else may have done exactly the same as you want.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Customize Ribbon
    By Poohbear0471 in forum Programming
    Replies: 2
    Last Post: 03-12-2019, 03:44 PM
  2. Replies: 5
    Last Post: 07-29-2018, 09:09 AM
  3. To customize Round ()
    By kiranair in forum Access
    Replies: 7
    Last Post: 06-01-2016, 08:45 AM
  4. Customize access db
    By joshynaresh in forum Access
    Replies: 7
    Last Post: 02-12-2014, 12:47 PM
  5. Customize Report X of Y
    By sachinmalik007 in forum Access
    Replies: 3
    Last Post: 05-04-2012, 08:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums