Results 1 to 7 of 7
  1. #1
    jaworski_m is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2015
    Posts
    25

    Buttons in customized ribbon disappear when "allow full menus" is disabled


    Hello,
    I customized ribbon for a pivot chart form using the below given code - it displays the only required buttons.
    However, when I disable "allow full menus" only empty tab is displayed.
    How can it be fixed?

    Ribbon's XML seems to be correct and the form's "RibbonName" property is also defined.
    I attached an image showing the problem.

    MS Access 2007

    Thank you for any suggestions.
    Code:
    <!-- Piovot chart ribbon -->
            <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
          <ribbon startFromScratch="true">
            <tabs>
              <tab id="PivotChartTools" label="Narzędzia wykresu">
                <group id="ChartTools" label="Narzędzia wykresu">
                      <toggleButton idMso="PivotFieldList" label="Lista dostępnych pól" size="large"/>
                      <toggleButton idMso="PivotDropAreas"  size="large"/>
                      <toggleButton idMso="PivotChartLegendShowHide" label="Pokaż legendę" size="large"/>
                </group>
              </tab>
            </tabs>
          </ribbon>
        </customUI>
    Attached Thumbnails Attached Thumbnails CustomRibbon-buttons invisible when Allow Full Menus disabled.jpg  

  2. #2
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614
    Not tested, try with the enabled="true" attribute for all the togglebuttons.

  3. #3
    jaworski_m is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2015
    Posts
    25
    Thank you for reply.
    Unfortunatelly,
    Code:
    enabled="true"
    is not working.
    Any other suggestions what might have been overlooked?

  4. #4
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614
    Tested, use visible="true" instead.

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    You can't use

    enabled="true"

    or

    Visible="true"

    for this! These are Boolean values...drop the Quotes

    Enabled= True

    or

    Visible=True

    Not saying that it will solve your problem, but it definitely won't using the Quotes.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614
    These are Boolean values...drop the Quotes
    The code I suggested is not for VBA. It has to be included in the attributes of the togglebuttons in Ribbon XML.
    Code:
    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
          <ribbon startFromScratch="true">
            <tabs>
              <tab id="PivotChartTools" label="Narzędzia wykresu">
                <group id="ChartTools" label="Narzędzia wykresu">
                      <toggleButton idMso="PivotFieldList" label="Lista dostępnych pól" size="large"    visible="true"/>
                      <toggleButton idMso="PivotDropAreas"  size="large"    visible="true"/>
                      <toggleButton idMso="PivotChartLegendShowHide" label="Pokaż legendę" size="large"    visible="true"/>
                </group>
              </tab>
            </tabs>
          </ribbon>
        </customUI>

  7. #7
    jaworski_m is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2015
    Posts
    25
    Code:
    visible="true"
    Works.
    Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  2. Replies: 2
    Last Post: 06-26-2012, 12:53 AM
  3. Replies: 11
    Last Post: 03-29-2012, 02:32 PM
  4. Replies: 2
    Last Post: 03-23-2012, 05:09 AM
  5. Replies: 1
    Last Post: 10-21-2010, 12:02 PM

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