UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Tools For Creating Custom Ribbons?, Any Version    
 
   
js909
post Sep 12 2019, 09:46 AM
Post#1



Posts: 11
Joined: 26-April 15



Besides IDBE Ribbon Creator and Visual Studio, are there any other "major" tools out there for creating and maintaining custom ribbons for Access? I prefer tools like these that allow for going back and forth between prototyping the layout visually and working in xml only when really needed. IDBE works fine, I've been using it for many years, but I'm always open to new tools. As far as I know at this point there were other ribbon creation tool projects started around about Access 2007 that were kind of half baked and then abandoned. What have I overlooked if anything? Thanks
Go to the top of the page
 
jleach
post Sep 12 2019, 09:50 AM
Post#2


UtterAccess Administrator
Posts: 10,281
Joined: 7-December 09
From: St. Augustine, FL


Hi,

I'm pretty sure that Gunter Avenius (sp?) has the best tool available for this, which is up to date for all versions of Office:

https://ribboncreator.de/en/

hth

--------------------
Jack D. Leach
Founder & CEO
Dymeng Services Inc.
Business Software Solutions
Go to the top of the page
 
GroverParkGeorge
post Sep 12 2019, 09:58 AM
Post#3


UA Admin
Posts: 36,201
Joined: 20-June 02
From: Newcastle, WA


Gunter’s tool is at the top of my list. I have been looking at a beta of a new addin that should be widely available soon. But at the moment it’s IDBE Ribbon Creator.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
jleach
post Sep 12 2019, 10:18 AM
Post#4


UtterAccess Administrator
Posts: 10,281
Joined: 7-December 09
From: St. Augustine, FL


Sorry, I didn't realize that IDBE was Gunter's tool

--------------------
Jack D. Leach
Founder & CEO
Dymeng Services Inc.
Business Software Solutions
Go to the top of the page
 
js909
post Sep 12 2019, 10:22 AM
Post#5



Posts: 11
Joined: 26-April 15



Thanks but let me clarify my question.. I think by now everyone working with custom ribbons knows IDBE is the front-runner in this category. I often purchase several software tools in a particular category because each has unique features that are worthwhile and lets face it, Access tools are for the most part dirt cheap. Back when Access 2007 was released I remember seeing at least several interesting ribbon creator tool projects. I can't recall most of the names now, MontaRibbon is the only other ribbon creation tool I remember. So in this post I'm wondering if anybody has been laboring in obscurity (lol) on an interesting ribbon creation tool that I might add to my toolkit along with IDBE and Visual Studio?

A perfect example of this development strategy is my recommendation to buy Code VBA, MZ-Tools, and Total Visual Code Tools. All three are wonderful products, I can't imagine not having all three. Which is the "best" tool? I'd be hard pressed to pick just one. They have many overlapping features but that is irrelevant compared to the many unique and useful features in each product.
Go to the top of the page
 
pere_de_chipstic...
post Sep 12 2019, 04:28 PM
Post#6


UtterAccess Editor
Posts: 10,515
Joined: 8-November 07
From: South coast, England


Just to be perverse, I don't use a ribbon creator, just a template like structure which I can copy and repeat for each command type.

e.g. All my button commands calling a function have the following structure and use the same Callbacks:
CODE
  <button id="fFunctionName"
               getLabel="rbnGetLabel"
               getScreentip="rbnGetSTip"  
               getVisible="RbnGetVis"
               getEnabled="RbnGetEna"
               getImage="RbnGetImage"
               onAction="RbnAct" />


the RbnAct callback then routes the code to the function defined by the ID of the button command.:
CODE
Sub rbnAct(ctrl As IRibbonControl)
On Error GoTo err_Proc

    Dim stAr() As String
    Dim strFunc As String
    Dim i As Byte
    
    Debug.Print ctrl.ID
    
    stAr = Split(ctrl.ID, "_")
    strFunc = stAr(0) & "("
    If UBound(stAr) > 0 Then
        For i = 1 To UBound(stAr)
            strFunc = strFunc & stAr(i) & ", "
        Next i
        strFunc = Left(strFunc, Len(strFunc) - 2)
    End If
    Debug.Print strFunc & ")"
    Eval strFunc & ")"

exit_Proc:
        Exit Sub

err_Proc:
    MsgBox Err.Description
    Debug.Print "Error:  Eval " & strFunc & ")"
    Resume exit_Proc

End Sub


This allows arguments to be passed from the Ribbon to the function as in: fFunctionName_Arg1_Arg2 as the ribbon XML control ID

GetVisible, getEnabled etc callbacks use a Select Case Statement:
CODE
Sub RbnGetVis(ctrl As IRibbonControl, ByRef Visible)
On Error GoTo err_Proc
    
    'This sets the visibility for ribbon controls
    
    Select Case ctrl.ID
    Case "RptStdTestEquipt_0", "RptStdTestEquipt_1"
        Visible = Screen.ActiveForm.Name = "frmCalibEquipt"                                            
    
    Case "fFindInstFile"
        Visible = Forms!frmEquipt!SelSubFrm = 0
    End Select


The only part of the ribbon XML that needs to be changed for each new command is each control ID.
Where different ribbon XML command types pass different arguments then different callbacks are needed, (e.g. command Buttons, toggleButtons, Comboboxes etc) but these are really quite small in number and effectively the 'heavy lifting' is transferred to VBA leaving the Ribbon XML easy to write!
This post has been edited by pere_de_chipstick: Sep 12 2019, 05:14 PM

--------------------
Warm regards
Bernie
Go to the top of the page
 
js909
post Sep 13 2019, 04:48 PM
Post#7



Posts: 11
Joined: 26-April 15



Thanks for the response, alternative approaches are always interesting. Myself I currently spend quite a lot of time in IDBE Ribbon Creator doing visual prototyping before I even think about generating the final ribbon for actual use. I spend a fair amount of time noodling what tabs I need, how to group functions, the structure of submenus, etc., and I often need to preview custom icons to see how they look together with the built-in Office icons. Using the IDBE software you always know exactly how the ribbon will look at runtime (except for built-in control groups like copy/paste, format, etc. which are shown as "place holders" in the ribbon design environment) and it makes it extremely easy to move controls around, modify menus and submenus, etc., until everything looks right. One of the interesting features of IDBE is that you can create your own templates for customized callbacks and of course your own VBA code to execute features so you aren't stuck with someone else's idea of what all that should look like.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th December 2019 - 05:00 AM