Results 1 to 6 of 6
  1. #1
    Boltsie is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2018
    Posts
    5

    Applying a custom ribbon

    Hi,



    I'm going around in circles.

    I have created two custom ribbons - one for 'Developer', one for 'User'. Quite straight forward really!

    I wish to use VBA to apply the ribbon depending on the user logged in. I can determine the type of user, that isn't a problem, I just don't know how to code the action of going into Options, Current Database, Ribbon Name.

    I have loaded the ribbons - that's all well and good, but I can't 'apply' the ribbon. Is the only way to do this, to assign the ribbon to a form? On load of the Switchboard for example?

    Any help would be very much appreciated.

    Thanks.

  2. #2
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    Hi boltsie,

    Do your users have their own personal computer or do people "desk hop". You could issue a different front end to people based on what you want them to be able to do or in this case what ribbon you want them to see.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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

  4. #4
    Boltsie is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2018
    Posts
    5
    Hi Homegrownandy!

    Thanks for responding! I like your thinking, but unfortunately under the circumstances the database is to be used, that won't work. Different people will be using the same front end.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Following on from Andy's idea you could have two different versions of your FE each with one of the ribbons.
    Then use a desktop shortcut to open a splash screen which checks the user status and opens the appropriate database for that user before itself quitting.

    However, I would check the links I provided first
    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

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Have a table of Users with their user type. Code retrieves USERNAME from Windows login and does a lookup to Users table to retrieve the user type and loads appropriate ribbon. Also disable the app X Close and File Exit as well as Right Click shortcut menu and function keys. Be aware that holding shift key while opening db will bypass code. Disabling shift key bypass is not something I have resorted to.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Custom Ribbon
    By June7 in forum Access
    Replies: 13
    Last Post: 08-01-2014, 02:44 AM
  2. Custom Ribbon question
    By croydon in forum Access
    Replies: 1
    Last Post: 12-13-2013, 10:34 AM
  3. Custom Button in Ribbon
    By chriscardwell06 in forum Access
    Replies: 3
    Last Post: 12-12-2013, 08:09 AM
  4. Custom Ribbon
    By nkuebelbeck in forum Programming
    Replies: 5
    Last Post: 08-25-2011, 11:55 AM
  5. Put an icon in a custom ribbon
    By ss3373 in forum Access
    Replies: 0
    Last Post: 06-21-2011, 05:52 AM

Tags for this Thread

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