see if this helps https://docs.microsoft.com/en-us/off...ui.activatetab
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
I use this to hide the Home tab in A2010 or later
I realise you don't want to hide the Home tab but try using TabHomeAccess in place of what you have nowCode:<tabs> <tab idMso="TabHomeAccess" visible="false" /> </tabs>
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
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.
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: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.HTML Code:https://www.microsoft.com/en-us/download/details.aspx?id=50745
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,which shows all attributes for tabs, groups and each control.HTML Code:https://docs.microsoft.com/en-us/openspecs/office_standards/ms-customui/141f881c-a5a4-473f-9449-55d3d36579ed
Thanks again to everybody for all of the help on this...
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
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.
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.