Solved

CUSTOM ACCESS RIBBON

Posted on 2014-09-12
19
244 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

839 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