Request for information on using the idQ attribute for custom ribbons in Access.

jacky Perpète 61

Hello,

I am looking for detailed information to understand the use of idQ attribute with custom ribbon in Access.

Following tests, I note for example that there are differences in display behavior when 2 ribbons share controls (idQ) between 2 forms with the startFromScratch attribute set to false or true.

With startFromScratch set to true, the display of split controls does not occur in the split tab.

With startFromScratch to false, the display is correct.

Is control sharing for custom ribbons provided for both values of this attribute?

According to tests, for shared controls (idQ), no callback procedure of these controls is called in the VBA code.

Is this normal?

I find a number of examples and explanations for Excel but not for Access.

jacky Perpète 61

Hello,

Here is in more detail, the result of my tests with the idQ attribute for which I am looking for information.

Here is the Xml code of the 2 ribbons, part of which is shared

rbForm1

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" xmlns:Q="Test">
	<ribbon startFromScratch="true">
		<tabs>
			<tab visible="true" label="Test idQ" idQ="Q:tab1">
				<group label="Test" idQ="Q:group1">
					<button size="large" label="Shared" imageMso="AppointmentColor1" idQ="Q:button1" onAction="rbForm1_OnAction"/>
					<button imageMso="AppointmentBusy" size="large" onAction="rbForm1_OnAction" id="button2" label="Form1"/>
				</group>
			</tab>
		</tabs>
	</ribbon>
</customUI>

rbForm2

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" xmlns:Q="Test">
	<ribbon startFromScratch="true">
		<tabs>
			<tab visible="true" label="Test idQ" idQ="Q:tab1">
				<group label="Test" idQ="Q:group1">
					<button imageMso="AppointmentColor3" size="large" id="button1" label="Form2"/>
				</group>
			</tab>
		</tabs>
	</ribbon>
</customUI>

Here is the illustration with the startFromScratch="false" attribute working perfectly fine.

TestIq_stFs_False

Here is the illustration with the startFromScratch="true" attribute not working.

The 'Test idQ' tab disappears when selecting the 'Form 2' form

TestIq_stFs_True

Here is the illustration of the 'OnAction' event on the unsplit button of the Form 1 form.

This event works correctly.

TestIq_OnactionOk

Here is the illustration of the 'OnAction' event on the Form 1 split button.

This event does not work.
TestIq_OnactionNoOk

Share via

Request for information on using the idQ attribute for custom ribbons in Access.

Your answer