Solved

CUSTOM ACCESS RIBBON

Posted on 2014-09-12
19
252 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 7
19 Comments
 
LVL 34

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

732 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