Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
  1. #16
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    see if this helps https://docs.microsoft.com/en-us/off...ui.activatetab
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  2. #17
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I use this to hide the Home tab in A2010 or later

    Code:
    <tabs>           <tab idMso="TabHomeAccess" visible="false" />
          </tabs>
    I realise you don't want to hide the Home tab but try using TabHomeAccess in place of what you have now
    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. #18
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    in your onRibbonLoad sub add the activatetab code as below. Replace "Away" with the ID of your tab.

    Code:
    Public globalRibbon As IRibbonUI
    
    
    Public Sub onRibbonLoad(ByVal ribbon As IRibbonUI)
    
    
        Set globalRibbon = ribbon
        
        ribbon.ActivateTab "Away"
    
    
    End Sub
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  4. #19
    RMittelman is offline Advanced
    Windows 10 Access 2016
    Join Date
    Dec 2010
    Location
    Simi Valley, CA
    Posts
    211
    Never mind, found and downloaded an Excel workbook from Microsoft that shows all tab, group and control ID's for built-in ribbon controls.
    Thanks to everybody who answered.

  5. #20
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I'm sure others would find that useful.
    Please upload either the workbook or the link where you found it
    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. #21
    RMittelman is offline Advanced
    Windows 10 Access 2016
    Join Date
    Dec 2010
    Location
    Simi Valley, CA
    Posts
    211
    I googled Office 2016 Fluent User Control. This took me to a page labelled Office 2016 Help Files: Office Fluent User Interface Control Identifiers


    Here is the link:
    HTML Code:
    https://www.microsoft.com/en-us/download/details.aspx?id=50745
    I believe you can find a page for other Office versions. There's a Download button. When I unzipped, the first file is called accesscontrols.xlsx. There are other workbooks there for Excel, Outlook, PowerPoint and Word.
    Getting the proper idMso let me properly place it before the Home tab. Didn't seem to need code to activate it. Either being the first tab after "File", it just opens. Or as mentioned before, I set the Ribbon property in Options > current database to the name of my custom tab. Maybe if it wasn't before the Home tab I'd have to activate it.

    Thanks isladogs and moke123, I found the answer before I saw you supplied it.

    Interestingly, when I edit the XML file in Visual Studio, it doesn't give me suggestions for attribute names for a given control as I type them in. The Access Jitsu videos shows it doing that in Visual Studio, but I don't get it, even though the proper schema is specified (although the videos use the older 2006 schema). This problem was mitigated when I found this article,
    HTML Code:
    https://docs.microsoft.com/en-us/openspecs/office_standards/ms-customui/141f881c-a5a4-473f-9449-55d3d36579ed
    which shows all attributes for tabs, groups and each control.

    Thanks again to everybody for all of the help on this...

  7. #22
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Thanks.
    For anyone else interested, the link to that page is https://www.microsoft.com/en-us/down....aspx?id=50745

    I've just downloaded the file and had a quick look.
    Its going to save me a lot of time as I'll no longer need to guess things like Tab names & ribbon control names.
    Pity its not supplied automatically with Office
    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

  8. #23
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Ha! That's another file that I lost. I had a Word doc with all the mso controls identified with pics and names too.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  9. #24
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I think I also had that at one time. Still 'discovering' files that I lost when my own hard drive failed in July. Or rather discovering I no longer have them.

    The most annoying losses were a couple of my old apps where I still have copies of the ACCDE but all ACCDB development versions were wiped out.
    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

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-25-2019, 12:59 AM
  2. Replies: 4
    Last Post: 08-07-2018, 05:38 AM
  3. Automating Outlook 2016 from Access 2016
    By jcc285 in forum Programming
    Replies: 10
    Last Post: 09-30-2017, 01:53 PM
  4. Use VBA to Rename a Default Ribbon Tab in Access 2016
    By jeffreymiller in forum Programming
    Replies: 1
    Last Post: 11-18-2016, 08:43 AM
  5. Replies: 4
    Last Post: 05-29-2015, 09:36 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