UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Hide File Tab In Ribbon, Office 2010    
 
   
sandrao
post Sep 13 2011, 10:42 AM
Post #1

UtterAccess Guru
Posts: 562
From: Montreal, QC



How do I hide the new file tab in access 2010 form appearing in the db when I distribute my program?
sandrao
Go to the top of the page
 
+
MikeLyons
post Sep 13 2011, 11:39 AM
Post #2

UtterAccess VIP
Posts: 1,923
From: BC, Canada



Haven't tried this but I found an article that might help.
ike
Go to the top of the page
 
+
sandrao
post Sep 13 2011, 03:29 PM
Post #3

UtterAccess Guru
Posts: 562
From: Montreal, QC



If you can't hide the file tab is it possible to hide the option button?
don't want others to go backstage as it were.
Any thoughts
sandrao
Go to the top of the page
 
+
MikeLyons
post Sep 13 2011, 03:52 PM
Post #4

UtterAccess VIP
Posts: 1,923
From: BC, Canada



Should be a matter of setting its visible attribute to false in a custom XML ribbon definition.
Keep in mind as well that if you are going to have others use your database you can use the Runtime Access which disables most of the commands on the File Tab anyway.
Mike
Go to the top of the page
 
+
sandrao
post Sep 13 2011, 04:24 PM
Post #5

UtterAccess Guru
Posts: 562
From: Montreal, QC



any idea what settings would be for the false attribute for the option button?
tried a view examples you included in you first comment but had no positive results.
sandrao
Go to the top of the page
 
+
MikeLyons
post Sep 13 2011, 04:37 PM
Post #6

UtterAccess VIP
Posts: 1,923
From: BC, Canada



Well did you try what was actually posted in the article for that Backstage tab?
!--c1-->
CODE
<button idMso="ApplicationOptionsDialog" visible="false"/>

Mike
Go to the top of the page
 
+
sandrao
post Sep 13 2011, 04:39 PM
Post #7

UtterAccess Guru
Posts: 562
From: Montreal, QC



Yes I did and there was no results.
try again and post my ribbon later.
sandrao
Go to the top of the page
 
+
HiTechCoach
post Sep 13 2011, 05:22 PM
Post #8

UtterAccess VIP
Posts: 18,666
From: Oklahoma City, Oklahoma



Curious, why are you needing to hide it?
Go to the top of the page
 
+
MikeLyons
post Sep 13 2011, 05:53 PM
Post #9

UtterAccess VIP
Posts: 1,923
From: BC, Canada



I am also wondering why -- as I mentioned already, if you are distributing your database as a runtime app, the runtime of Access 2010 removes the Options and most other items from the Backstage view. You might be attempting to go to a lot of effort for nothing. If the users will be using the full MS Access then you can change the filename extension on your application from ACCDE (you should be distributing that, not an ACCDB version, to protect your code) to ACCDR to cause Access to go into runtime mode.
ike
Go to the top of the page
 
+
AlbertKallal
post Sep 13 2011, 09:30 PM
Post #10

UtterAccess VIP
Posts: 2,031
From: Edmonton, Alberta Canada



Just as a quick heads up, any "settings" to backstage MUST be placed in the application wide ribbon. You cannot change these settings by using xml ribbons specified for a form or report.
So, we are talking about the system wide ribbon you set in the application startup. I would probably just put in a "about" text and perhaps a exit. Or even consider moving your existing custom File options to the back stage and you get rid of having "two" file options.
The xml for hiding this stuff is:
CODE
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="true">
  </ribbon>
  <backstage>
<button idMso="ApplicationOptionsDialog" visible="false"/>
    <tab idMso="TabInfo" visible="false"/>
    <button idMso="FileSave" visible="false"/>
    <button idMso="SaveObjectAs" visible="false"/>
    <button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
    <button idMso="FileOpen" visible="false"/>
    <button idMso="FileCloseDatabase" visible="false"/>
    <tab idMso="TabRecent" visible="false"/>
    <tab idMso="TabNew" visible="false"/>
    <tab idMso="TabPrint" visible="false"/>
    <tab idMso="TabShare" visible="false"/>
    <tab idMso="TabHelp" visible="false"/>
    <button idMso="ApplicationOptionsDialog" visible="false"/>
    <button idMso="FileExit" visible="false"/>
  </backstage>
</customUI>

HAs noted, above xml must be set in the file->options current database as backstage options can ONLY be set from the application wide ribbon, not ones specified for each form or report.
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
kallal@msn.com
Go to the top of the page
 
+
sandrao
post Sep 14 2011, 03:54 PM
Post #11

UtterAccess Guru
Posts: 562
From: Montreal, QC



Just a few more comments.
Ohve just moved from Access 2007 to 2010 and I am not familiar with the file tab.
I am not sure if I have to save all my db's in 2010 tor the ribbon to work or not.
The reason was I want to limit visibility with the file tab is that the programs are
install on a few other computers. I know I could packable them all in Access Runtime but
that would be a hassel for making changes in the other computers.
sandrao
Go to the top of the page
 
+
AlbertKallal
post Sep 15 2011, 10:34 PM
Post #12

UtterAccess VIP
Posts: 2,031
From: Edmonton, Alberta Canada



There's no need to upgrade from 2007 format to 2010 format for use of ribbon.
On fact 2007 and 2010 share the SAME file format despite 2010 having a different set of features that you can stuff into that supposedly same file format (so there is only a 2007-2010 format just like access 2002/2003 also shared the same format).
>I am not familiar with the file tab.
In most of the office of programs for years and years, every one of them has a file option in the upper left corner on the menu. Office has been this way for about 20 years now.
So the file option we are talking about is this one:

The only exception and confusing version of Access is of course Access 2007 in which they changed this to a little pizza button. That pizza button was the same as "file" in a sense.
However for 2010, they changed that option back to File as many users did not realize you could actually click on the pizza button. You can thus customize what this option shows, and even just have a "exit" option for this.
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
kallal@msn.com
Go to the top of the page
 
+
sandrao
post Sep 16 2011, 08:18 AM
Post #13

UtterAccess Guru
Posts: 562
From: Montreal, QC



I did manage to find info for hiding the options in the file tab.
On my post "ribbon backstage" I posted the ribbons, but no I have another request if you would see
My question in my other post.
sandrao
This works:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="false">
<!-- Ihre Ribbon Definition -->
</ribbon>
<backstage>
<tab idMso="TabInfo" visible="true"/>
<button idMso="FileSave" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
<button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
<tab idMso="TabRecent" visible="false"/>
<tab idMso="TabNew" visible="false"/>
<tab idMso="TabPrint" visible="false"/>
<tab idMso="TabShare" visible="false"/>
<tab idMso="TabHelp" visible="false"/>
<button idMso="ApplicationOptionsDialog" visible="false"/>
<button idMso="FileExit" visible="false"/>
</backstage
>

</customUI>
But How do I intergrate this (in Red) in my own ribbon code
the code below?
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<tabs>
<tab idMso="TabHomeAccess" label="Home" visible="false" />
<tab idMso="TabCreate" label="Create" visible="true" />
<tab idMso="TabExternalData" label="External Data" visible="true" />
<tab idMso="TabDatabaseTools" label="Database Tools" visible="false" />
<tab id="dbCustomTab" label="Service Meeting Program" visible="true">

</group>
<group id="PrintOptions" label="Printing Options">
<button id="Print01" label="Printing Schedule" imageMso="PrintOptionsMenu" size="large" onAction="=MyForm('PrintOptions')"
supertip= "Select Pringing options for Meeting Schedules"/>
</group>
<group id="grpPrint22" label="Utilities" visible="true">
<button idMso="PrintDialogAccess" size="large" />
<button idMso="PageSetupDialog" size="large"/>
<button idMso="FileSaveAsPdfOrXps" size="large" visible="true" label="PDF" />
<button idMso="SpellingAccess" size="large" visible="true" label="Spelling" />
<button idMso="FileCloseDatabase" size="large" visible="true" label="Close Database" />


</group>
</tab>
</tabs>
</ribbon>
</backstage>
</customUI>
sandrao
Go to the top of the page
 
+
Sampaio
post Sep 18 2011, 03:52 AM
Post #14

SEO Back Linker
Posts: 61
From: Brazil



Download example
Attached File(s)
Attached File  Sandrao2.zip ( 24.94K ) Number of downloads: 199
 
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 24th October 2014 - 11:47 AM

Tag cloud: