Solved

CUSTOM ACCESS RIBBON

Posted on 2014-09-12
19
233 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 32

Assisted Solution

by:Stefan Hoffmann
Stefan Hoffmann earned 100 total points
Comment Utility
Use Gunter's RibbonCreator.
0
 
LVL 7

Author Comment

by:COACHMAN99
Comment Utility
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

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
 
LVL 7

Author Comment

by:COACHMAN99
Comment Utility
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
Comment Utility
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

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Cool.  Can you post a screen shot show what this looks like ... just for reference.
thx.mx
0
 
LVL 7

Author Comment

by:COACHMAN99
Comment Utility
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
Comment Utility
closed too soon
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
'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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 7

Author Comment

by:COACHMAN99
Comment Utility
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
Comment Utility
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

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
start from scratch = false

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

Author Comment

by:COACHMAN99
Comment Utility
false and true have the same effect (apparently nothing?) -  'Home' disappears in runtime environment.
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
Comment Utility
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 - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 200 total points
Comment Utility
"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
Comment Utility
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

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
Comment Utility
it works
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now