Results 1 to 8 of 8
  1. #1
    As226 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Posts
    9

    Access custom ribbon


    Hello
    I need your help to solve my problem.
    I'm trying to build a custom ribbon on access, i would like to enable and disable a button on the ribbon due to a field value on my form.
    In fact, with the form ''test'' if i have ''OK'' in the field named ''keyword'' button ''test'' on ribbon must be enabled, else disabled.
    And it must be like this on every change the field value.
    Please help me.
    https://www.cjoint.com/c/IEve6EsVH6E
    Thank in advance


    Regards

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    I have 't looked at your link.
    I recommend you look at the ribbon creator utility by Gunter Avenius. A free evaluation version is available
    His site includes various examples and tutorials which may well do what you need.

    The site is in German but an English version is also available. See e.g. 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
    As226 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Posts
    9
    Hi Isla
    Thank for your message.
    I tried this and many others tutorials but sometimes it work, sometimes not.
    Perhaps i forget something.
    Can you help me please?

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    I'm not a ribbon expert and don't have time to assist at the moment.
    Suggest you post your existing ribbon code or a cut down version of your app for someone to look at /offer suggestions
    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
    As226 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Posts
    9
    Here is the link of my database.
    https://www.cjoint.com/c/IEve6EsVH6E

    Thank you

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Please upload it to this site. Many forum members including myself will not download from external sites
    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

  7. #7
    As226 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Posts
    9
    This is my database
    Database7.zip

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,791
    I took a quick look but have no idea where the button should be regardless of whether or not the form code works. I think you will find this quite valuable as it shows how to do things like swap buttons

    http://www.kallal.ca/Ribbon/ribbon.htm
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Making a Custom Ribbon in Access
    By Timothy in forum Programming
    Replies: 5
    Last Post: 07-07-2017, 04:57 PM
  2. Custom Ribbon
    By June7 in forum Access
    Replies: 13
    Last Post: 08-01-2014, 02:44 AM
  3. Modules in custom ribbon
    By Derrick T. Davidson in forum Programming
    Replies: 1
    Last Post: 04-07-2013, 07:51 PM
  4. custom Ribbon question
    By jscriptor09 in forum Access
    Replies: 0
    Last Post: 07-17-2012, 02:35 PM
  5. Custom Ribbon
    By nkuebelbeck in forum Programming
    Replies: 5
    Last Post: 08-25-2011, 11:55 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