CUSTOM ACCESS RIBBON

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
LVL 7
COACHMAN99Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
Use Gunter's RibbonCreator.
0
COACHMAN99Author Commented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

COACHMAN99Author Commented:
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
COACHMAN99Author Commented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Cool.  Can you post a screen shot show what this looks like ... just for reference.
thx.mx
0
COACHMAN99Author Commented:
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
COACHMAN99Author Commented:
closed too soon
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
'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
COACHMAN99Author Commented:
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
COACHMAN99Author Commented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
start from scratch = false

>> start from scratch = true
This denotes a Custom Ribbon
0
COACHMAN99Author Commented:
false and true have the same effect (apparently nothing?) -  'Home' disappears in runtime environment.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
COACHMAN99Author Commented:
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
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
COACHMAN99Author Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
COACHMAN99Author Commented:
it works
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.