Solved

CUSTOM ACCESS RIBBON

Posted on 2014-09-12
19
250 Views
Last Modified: 2014-09-17
Hi All,
does anyone have the xml script to provide ONLY the sort and filter section of the ribbon?
I need this displayed when the db is used in a runtime environment.

thank you
0
Comment
Question by:COACHMAN99
  • 11
  • 7
19 Comments
 
LVL 33

Assisted Solution

by:ste5an
ste5an earned 100 total points
ID: 40319803
Use Gunter's RibbonCreator.
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 40319935
Thanks for the tip
I was hoping to 'plug-and-play' a short block of XML, rather  than learning a new app (which I will do when I have time :-0)
0
 
LVL 75
ID: 40320019
Actually ... here is a link to Gunter's downloads   ... some 30 sample dbs with various techniques. You might find what you need here.  I have every sample db on my systems :-)

Also ... I HIGHLY recommend using Ribbon Creator, as I have for a couple of years. Without his tool, creating custom Ribbons would be a nightmare.

mx
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Author Comment

by:COACHMAN99
ID: 40320043
This is what I came up with - seems to work OK
<?xml version="1.0" encoding="utf-8"?>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="true">
    <tabs>
<tab idMso="TabHomeAccess" visible="true" />
     <group idMso="GroupSortAndFilter"></group>
     <group idMso="GroupFindAccess"></group>
    </tabs>
  </ribbon>
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 40320129
I've requested that this question be closed as follows:

Accepted answer: 0 points for COACHMAN99's comment #a40320043
Assisted answer: 166 points for ste5an's comment #a40319803
Assisted answer: 166 points for DatabaseMX (Joe Anderson - Access MVP)'s comment #a40320019

for the following reason:

it is what I needed - a small block of xml.

maybe I have to learn to use one of the other tools. :-)
0
 
LVL 75
ID: 40320059
Cool.  Can you post a screen shot show what this looks like ... just for reference.
thx.mx
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 40320127
Unfortunately not so 'cool':
Untitled.pngThe xml shows the home (and filter) tabs in full Access, but the Home disappears in runtime - any suggestions would be most welcome.
thanks
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 40320130
closed too soon
0
 
LVL 75
ID: 40320142
'runtime' as in the Runtime Version of Access ?
If so ... pretty sure you have to create your own Custom Ribbon ... since built in menus (now Ribbons) are not available in Runtime.

mx
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 40320144
I should add that this is an mdb running on W7 / Office 2010 runtime (and even if I change it to accdb the Home tab still disappears in runtime)
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 40320146
I was under the (misguided :-)) impression that using usysRibbon and 'start from scratch = false was creating a custom ribbon?
Is there a completely different mechanism
cheers
0
 
LVL 75
ID: 40320155
start from scratch = false

>> start from scratch = true
This denotes a Custom Ribbon
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 40320172
false and true have the same effect (apparently nothing?) -  'Home' disappears in runtime environment.
0
 
LVL 75
ID: 40320180
Yes ... but ... is the Ribbon above a Custom ribbon you created from start ?
Or are you trying to use the built in Ribbons also ?
0
 
LVL 7

Author Comment

by:COACHMAN99
ID: 40320192
I added the usysribbons table,
added 1 record with the xml (above)
set the current database options ribbon to the name in the record
unset 'Allow full menus'

Am I 'using a custom menu'?

the full access platform works fine, the runtime briefly displays the 'Home' tab then it disappears, leaving 'File' only.
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 200 total points
ID: 40320282
"unset 'Allow full menus'"
btw ... I have found this needs to be checked - when using a Custom Ribbon.  Although not related per se to this issue.

Not sure what is up ... but I might suggest you grab a sample custom ribbon USysRibbons table from one of Gunter's sample dbs ... and then see .... if all of it shows in the Runtime mode ... if you see what I mean ?

mx
0
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 0 total points
ID: 40320534
THANKS MX,
I finally got this to work using the following code. I don't know why, but the contextualtabs seems to have something to do with the outcomes. Not going to spend any more time on this - cheers.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
 <ribbon startFromScratch="true">
  <contextualTabs>
   <tabSet idMso="TabSetFormReportExtensibility">
    <tab id="MyTab" label="Form">
     <group idMso="GroupClipboard"></group>
     <group idMso="GroupRecords"></group>
     <group idMso="GroupSortAndFilter"></group>
     <group idMso="GroupFindAccess"></group>
    </tab>
   </tabSet>
  </contextualTabs>
 </ribbon>
</customUI>
0
 
LVL 75
ID: 40320536
Interesting.
Regarding Contextual Tabs .... I had to add a Contextual Tab snippet in order to ... prevent a couple of built in Contextual Tabs (Forms, Design) from appearing when I clicked into a Datasheet subform on a Main Form ... MADDENING.  Just on of the many nuances of Ribbons.  I found the info on Gunter's site.

Seriously ... Ribbon Creator is light years beyond all other so call 'custom ribbon tools' put together. Once you get the hang of it ... and realize all the things he has taken into account, it's REALLY cool !

mx
0
 
LVL 7

Author Closing Comment

by:COACHMAN99
ID: 40327538
it works
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question