Results 1 to 3 of 3
  1. #1
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50

    Custom Ribbons and the Tab

    I have managed to make a Custom Ribbon XML with several tabs each containing buttons and menus. It all looks great now. The buttons have a OnAction function and when the button is clicked it does something.



    My question is: Is the same thing possible when a tab clicked? What it needs to do is: you click the Tab and then it has to set focus to a form. When another Tab is clicked it needs to set focus to the another form.

    Not sure if this is possible so any suggestions are welcome.

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    I dont think access supports this level of automation.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Apparently in Word, you can switch ribbon tabs on document open via vba, so I suspect you can trap which Access ribbon tab is clicked on.
    I just don't know how at present.

    EDIT: found this on tab visibility. Perhaps it will help you, but I can't take the time to look at the posted db that supposedly works. I'm thinking it would lead you to trap that a particular tab becomes active.
    http://www.access-programmers.co.uk/...d.php?t=246015
    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. Using Late Binding in creating custom ribbons
    By Demerit in forum Programming
    Replies: 2
    Last Post: 08-25-2015, 04:17 PM
  2. Replies: 2
    Last Post: 10-12-2013, 07:39 AM
  3. Replies: 4
    Last Post: 08-01-2013, 08:43 AM
  4. Making and Using Customized Ribbons
    By ebrommhead in forum Programming
    Replies: 1
    Last Post: 04-05-2013, 01:00 PM
  5. Creating Custom Ribbons
    By disco_stu in forum Access
    Replies: 1
    Last Post: 07-13-2010, 06:10 PM

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