abcctech
asked on
Microsoft Access 2010: How to Hide File tab and also Hide Min Ribbon Bar, Access Help, Min, Restore, Close on the right/top of screen
Help! I’m new to Access 2010 and trying to create Ribbon Bars…
I can’t seem to “hide” the File portion of the Ribbon bar. When I create the ribbon bar and put it on a form I still see the File tab and Save, Save Object As, Save Db As, Open, Close db, List of recent db’s opened, Info, Recent, New, Print, Save & Publish, Help, Options, Exit
On my Main Menu form I Hide the Navigation Pane on the Open Method:
DoCmd.SelectObject acTable, "ProjectInfo", True
If Application.CurrentObjectN ame = "ProjectInfo" Then DoCmd.RunCommand acCmdWindowHide
I’ve created a table called: USysRibbons
-contains the ribbon bars I created
On the forms I put in the Ribbon Name from the USysRibbons table
Here is an example of my ribbon bar:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<qat>
<sharedControls>
</sharedControls>
<documentControls>
</documentControls>
</qat>
<tabs>
<tab id="dbCustomTabFile" label="File" visible="true">
<group id="dbCustomGroupFile" label="File Group">
<control idMso="MasterViewClose" label="Close Screen" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabEdit" label="Edit" visible="true">
<group id="dbCustomGroupEdit" label="Edit Group">
<control idMso="Undo" label="Undo" enabled="true"/>
<control idMso="Cut" label="Cut" enabled="true"/>
<control idMso="Copy" label="Copy" enabled="true"/>
<control idMso="Paste" label="Paste" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabPrint" label="Print" visible="true">
<group id="dbCustomGroupPrint" label="Print Group">
<control idMso="FilePrintQuick" label="Quick Print" enabled="true"/>
<control idMso="FilePrintMenu" label="FilePrintMenu" enabled="true"/>
<control idMso="PrintPreviewClose" label="Close Print Preview" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabHelp" label="Help" visible="true">
<group id="dbCustomGroupHelp" label="Help Group">
<control idMso="SpellingAccess" label="Spelling" enabled="true"/>
<button id = "OpenForm" imageMso ="Help" label = "Data Entry Help" onAction = "OnButtonPress" tag="Help"/>
<control idMso="ViewsDesignView" label="ABCC Only (D)" enabled="true"/>
<control idMso="ViewsLayoutView" label="ABCC Only (L)" enabled="true"/>
</group>
</tab>
</tabs>
</ribbon>
<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
<button idMso="FileSaveAsCurrentFi leFormat" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileSave" visible="false"/>
<tab idMso="TabInfo" visible="false"/>
<tab idMso="TabRecent" visible="false"/>
<tab idMso="TabNew" visible="false"/>
<tab idMso="TabPrint" visible="true"/>
<tab idMso="TabShare" visible="false"/>
<tab idMso="TabHelp" visible="false"/>
<button idMso="ApplicationOptionsD ialog" visible="false"/>
<button idMso="FileExit" visible="false"/>
</backstage>
</customUI>
I thought the <backstage> portion would ‘hide’ the File tab… But it’s still there.
Also how do you hide the functions on the right side of the screen (Min Ribbon Bar, Access Help, Min, Restore, Close)
Thanks in advance for any suggestions
Thanks,
Donna
I can’t seem to “hide” the File portion of the Ribbon bar. When I create the ribbon bar and put it on a form I still see the File tab and Save, Save Object As, Save Db As, Open, Close db, List of recent db’s opened, Info, Recent, New, Print, Save & Publish, Help, Options, Exit
On my Main Menu form I Hide the Navigation Pane on the Open Method:
DoCmd.SelectObject acTable, "ProjectInfo", True
If Application.CurrentObjectN
I’ve created a table called: USysRibbons
-contains the ribbon bars I created
On the forms I put in the Ribbon Name from the USysRibbons table
Here is an example of my ribbon bar:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<qat>
<sharedControls>
</sharedControls>
<documentControls>
</documentControls>
</qat>
<tabs>
<tab id="dbCustomTabFile" label="File" visible="true">
<group id="dbCustomGroupFile" label="File Group">
<control idMso="MasterViewClose" label="Close Screen" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabEdit" label="Edit" visible="true">
<group id="dbCustomGroupEdit" label="Edit Group">
<control idMso="Undo" label="Undo" enabled="true"/>
<control idMso="Cut" label="Cut" enabled="true"/>
<control idMso="Copy" label="Copy" enabled="true"/>
<control idMso="Paste" label="Paste" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabPrint" label="Print" visible="true">
<group id="dbCustomGroupPrint" label="Print Group">
<control idMso="FilePrintQuick" label="Quick Print" enabled="true"/>
<control idMso="FilePrintMenu" label="FilePrintMenu" enabled="true"/>
<control idMso="PrintPreviewClose" label="Close Print Preview" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabHelp" label="Help" visible="true">
<group id="dbCustomGroupHelp" label="Help Group">
<control idMso="SpellingAccess" label="Spelling" enabled="true"/>
<button id = "OpenForm" imageMso ="Help" label = "Data Entry Help" onAction = "OnButtonPress" tag="Help"/>
<control idMso="ViewsDesignView" label="ABCC Only (D)" enabled="true"/>
<control idMso="ViewsLayoutView" label="ABCC Only (L)" enabled="true"/>
</group>
</tab>
</tabs>
</ribbon>
<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
<button idMso="FileSaveAsCurrentFi
<button idMso="FileOpen" visible="false"/>
<button idMso="FileSave" visible="false"/>
<tab idMso="TabInfo" visible="false"/>
<tab idMso="TabRecent" visible="false"/>
<tab idMso="TabNew" visible="false"/>
<tab idMso="TabPrint" visible="true"/>
<tab idMso="TabShare" visible="false"/>
<tab idMso="TabHelp" visible="false"/>
<button idMso="ApplicationOptionsD
<button idMso="FileExit" visible="false"/>
</backstage>
</customUI>
I thought the <backstage> portion would ‘hide’ the File tab… But it’s still there.
Also how do you hide the functions on the right side of the screen (Min Ribbon Bar, Access Help, Min, Restore, Close)
Thanks in advance for any suggestions
Thanks,
Donna
ASKER
Hi mx,
I agree with you we absolutely need to find a way to hide that "FIND" tab...
When I put in DoCmd.ShowToolBar "ribbon", acToolBarNo. I no longer see my customized ribbon...
I need to have that ribbon on the screen...
Why doesn't the <backstage> thing work? Does anyone know?
This is insane.... I have 22 db's that have to be converted to Access 2010!
I agree with you we absolutely need to find a way to hide that "FIND" tab...
When I put in DoCmd.ShowToolBar "ribbon", acToolBarNo. I no longer see my customized ribbon...
I need to have that ribbon on the screen...
Why doesn't the <backstage> thing work? Does anyone know?
This is insane.... I have 22 db's that have to be converted to Access 2010!
what FInd tab? can you show a pic of it?
Find tab >> File tab
mx
mx
try this
access options>>current database>> document window options
select document "tabbed Documents"
uncheck "display Document tabs"
ee2.bmp
access options>>current database>> document window options
select document "tabbed Documents"
uncheck "display Document tabs"
ee2.bmp
ASKER
Sorry I meant File Tab..
See the 2 File tabs below... The First one is the one that has to be hidden and I can't find how to hide it.
File1.png
See the 2 File tabs below... The First one is the one that has to be hidden and I can't find how to hide it.
File1.png
here try the below code.
* note that all of the things you can make not visible are done with <ribbon startFromScratch="true"> * with the exception of the help button.
so your "backstage" section is unnecessary.
i am using 07 so i cant test the below code i changed the schema/ the first line. change it back to
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
'---------------code
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<commands>
<command idMso="Help" enabled="false"/>
</commands>
<ribbon startFromScratch="true">
<tabs>
<tab id="dbCustomTabFile" label="File" visible="true">
<group id="dbCustomGroupFile" label="File Group">
<control idMso="MasterViewClose" label="Close Screen" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabEdit" label="Edit" visible="true">
<group id="dbCustomGroupEdit" label="Edit Group">
<control idMso="Undo" label="Undo" enabled="true"/>
<control idMso="Cut" label="Cut" enabled="true"/>
<control idMso="Copy" label="Copy" enabled="true"/>
<control idMso="Paste" label="Paste" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabPrint" label="Print" visible="true">
<group id="dbCustomGroupPrint" label="Print Group">
<control idMso="FilePrintQuick" label="Quick Print" enabled="true"/>
<control idMso="FilePrintMenu" label="FilePrintMenu" enabled="true"/>
<control idMso="PrintPreviewClose" label="Close Print Preview" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabHelp" label="Help" visible="true">
<group id="dbCustomGroupHelp" label="Help Group">
<control idMso="SpellingAccess" label="Spelling" enabled="true"/>
<button id = "OpenForm" imageMso ="Help" label = "Data Entry Help" onAction = "OnButtonPress" tag="Help"/>
<control idMso="ViewsDesignView" label="ABCC Only (D)" enabled="true"/>
<control idMso="ViewsLayoutView" label="ABCC Only (L)" enabled="true"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
* note that all of the things you can make not visible are done with <ribbon startFromScratch="true"> * with the exception of the help button.
so your "backstage" section is unnecessary.
i am using 07 so i cant test the below code i changed the schema/ the first line. change it back to
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
'---------------code
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<commands>
<command idMso="Help" enabled="false"/>
</commands>
<ribbon startFromScratch="true">
<tabs>
<tab id="dbCustomTabFile" label="File" visible="true">
<group id="dbCustomGroupFile" label="File Group">
<control idMso="MasterViewClose" label="Close Screen" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabEdit" label="Edit" visible="true">
<group id="dbCustomGroupEdit" label="Edit Group">
<control idMso="Undo" label="Undo" enabled="true"/>
<control idMso="Cut" label="Cut" enabled="true"/>
<control idMso="Copy" label="Copy" enabled="true"/>
<control idMso="Paste" label="Paste" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabPrint" label="Print" visible="true">
<group id="dbCustomGroupPrint" label="Print Group">
<control idMso="FilePrintQuick" label="Quick Print" enabled="true"/>
<control idMso="FilePrintMenu" label="FilePrintMenu" enabled="true"/>
<control idMso="PrintPreviewClose" label="Close Print Preview" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabHelp" label="Help" visible="true">
<group id="dbCustomGroupHelp" label="Help Group">
<control idMso="SpellingAccess" label="Spelling" enabled="true"/>
<button id = "OpenForm" imageMso ="Help" label = "Data Entry Help" onAction = "OnButtonPress" tag="Help"/>
<control idMso="ViewsDesignView" label="ABCC Only (D)" enabled="true"/>
<control idMso="ViewsLayoutView" label="ABCC Only (L)" enabled="true"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
***
i am using 07 so i cant test the below code i changed the schema/ the first line. change it back to
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
change it back if you recieve an error**
i am using 07 so i cant test the below code i changed the schema/ the first line. change it back to
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
change it back if you recieve an error**
here is a good link to check out on ribbons that i came accross
http://msdn.microsoft.com/en-us/library/dd909370(v=office.12).aspx
http://msdn.microsoft.com/en-us/library/dd909370(v=office.12).aspx
this looks like the link where the answer would be if there is one
http://msdn.microsoft.com/en-us/office/aa905530.aspx
http://msdn.microsoft.com/en-us/office/aa905530.aspx
ASKER
Hi Conagraman,
I tried your code and still see the whole microsoft File tab (as is was before). I was so hoping this would work. Does it work in Access 07? Do you think they totally changed it in Access 2010? Is that why it's not working??
I'm checking out those 2 links you sent. So far, I haven't see anything that would help but I'll keep looking in there.
The "Backstage" stuff I see all over (like in my original code) just doesn't work...
I tried your code and still see the whole microsoft File tab (as is was before). I was so hoping this would work. Does it work in Access 07? Do you think they totally changed it in Access 2010? Is that why it's not working??
I'm checking out those 2 links you sent. So far, I haven't see anything that would help but I'll keep looking in there.
The "Backstage" stuff I see all over (like in my original code) just doesn't work...
just to be sure: you do know your asking for a file tab?
<tab id="dbCustomTabFile" label="File" visible="true">
<group id="dbCustomGroupFile" label="File Group">
<control idMso="MasterViewClose" label="Close Screen" enabled="true"/>
</group>
</tab>
<tab id="dbCustomTabFile" label="File" visible="true">
<group id="dbCustomGroupFile" label="File Group">
<control idMso="MasterViewClose" label="Close Screen" enabled="true"/>
</group>
</tab>
i cant help you with the backstage stuff. its only in 2010. here is a link for it
http://msdn.microsoft.com/en-us/office/ff808348.aspx
http://msdn.microsoft.com/en-us/office/ff808348.aspx
i dont see the file tab. if the code dosent help i'd wonder if you can get rid of it.
in 07 i cant get rid of the "microsoft button" i wonder if they changed it to the "file" button.
in 07 i cant get rid of the "microsoft button" i wonder if they changed it to the "file" button.
ya thats exactly what it looks like. they replaced the "office" button with a file tab. i have tried everything to hide that. ur prob sol.
ASKER
What is in the Microsoft Button? Does it have: Save, Save Object As, Save Db As, Open, Close db, List of recent db’s opened, Info, Recent, New, Print, Save & Publish, Help, Options, Exit? That is what is in the File Tab now...
The Code: <tab id="dbCustomTabFile" label="File" visible="true"> is to show "My" version of the file tab I want my users to see.
The Backstage stuff (from what I am reading..) is to manipulate the "File Tab" stuff.
<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
I'm trying to make them "Not visible"... Well at least I'm trying and it's not working...
How do you work around the Microsoft Button?
The Code: <tab id="dbCustomTabFile" label="File" visible="true"> is to show "My" version of the file tab I want my users to see.
The Backstage stuff (from what I am reading..) is to manipulate the "File Tab" stuff.
<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
I'm trying to make them "Not visible"... Well at least I'm trying and it's not working...
How do you work around the Microsoft Button?
see my last post. there is no work around.
what i can do is hide almost all of the options that appear. sounds like the same thing as the backstage. so there is almost nothing on the menu except a close button
ASKER
Yes, that is what I am trying to do with the backstage thing... But it's just not working.
Do you have the code that hides all but the close button?
This shouldn't be that hard should it? Why do they do this to us? You would think that would be an option because that file tab is so powerful and the user can ruin your database that you just wrote!
There should be an option to just turn it off!
Do you have the code that hides all but the close button?
This shouldn't be that hard should it? Why do they do this to us? You would think that would be an option because that file tab is so powerful and the user can ruin your database that you just wrote!
There should be an option to just turn it off!
try this command
docmd.showtoolbar "ribbon",actoolbarno
ASKER
Hi Capricon1,
if I use: DoCmd.ShowToolbar "Ribbon", acToolbarNo then I don't see the File tab (which is what I want) but I do not see my customized ribbons either.
This is driving me insane...
if I use: DoCmd.ShowToolbar "Ribbon", acToolbarNo then I don't see the File tab (which is what I want) but I do not see my customized ribbons either.
This is driving me insane...
ok
place this code in between <ribbon startFromScratch="true"> and <tabs>
in your xml so for example <ribbon startFromScratch="true"> the below code goes here----<tabs>
<officeMenu>
<control idMso="FileNewDatabase" visible="false"/>
<control idMso="SourceControlCreate DatabaseFr omProject" visible="false"/>
<control idMso="FileOpenDatabase" visible="false"/>
<control idMso="FileSave" visible="false"/>
<control idMso="ConvertDatabaseForm at" visible="false"/>
<control idMso="FileSaveAsMenuAcces s" visible="false"/>
<control idMso="FileManageMenu" visible="false"/>
<control idMso="FileSendAsAttachmen t" visible="false"/>
<control idMso="MenuPublish" visible="false"/>
<control idMso="FileServerMenu" visible="false"/>
<control idMso="FileCloseDatabase" visible="false"/>
</officeMenu>
place this code in between <ribbon startFromScratch="true"> and <tabs>
in your xml so for example <ribbon startFromScratch="true"> the below code goes here----<tabs>
<officeMenu>
<control idMso="FileNewDatabase" visible="false"/>
<control idMso="SourceControlCreate
<control idMso="FileOpenDatabase" visible="false"/>
<control idMso="FileSave" visible="false"/>
<control idMso="ConvertDatabaseForm
<control idMso="FileSaveAsMenuAcces
<control idMso="FileManageMenu" visible="false"/>
<control idMso="FileSendAsAttachmen
<control idMso="MenuPublish" visible="false"/>
<control idMso="FileServerMenu" visible="false"/>
<control idMso="FileCloseDatabase" visible="false"/>
</officeMenu>
i dont have 2010 so you will have to work off of what i have here and hope there is something like it.
in 2007 i would uncheck the "allow full menus" in my ribbon options. see the below pic. again this is 07 non 2010 so it might look a bit different.
eerib.bmp
in 2007 i would uncheck the "allow full menus" in my ribbon options. see the below pic. again this is 07 non 2010 so it might look a bit different.
eerib.bmp
thats it.
ASKER
you will see the file tab no matter what you try. what i am saying is you can hide all the options it would bring up.
this means i went from the normal menu to just recent documents and a close button. its not ideal but the best i think you can get.
eemenu.bmp
eemenu.bmp
ASKER
Yes, I understand that now... I will still see "File" but nothing should be in there. Right? Unfortunately, I still see the file tab and all of it's contents...
with this code:
<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
<button idMso="FileSaveAsCurrentFi leFormat" visible="false"/>
<button idMso="FileOpen" visible="false"/>
.......
with this code:
<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
<button idMso="FileSaveAsCurrentFi
<button idMso="FileOpen" visible="false"/>
.......
ASKER
Oh I wish I could just do what you have up there!!!
That has to be doable in 2010! Doesn't anyone else use 2010 out there?
That has to be doable in 2010! Doesn't anyone else use 2010 out there?
you could try
<backstage>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="SourceControlCreate DatabaseFr omProject" visible="false"/>
<button idMso="FileOpenDatabase" visible="false"/>
<button idMso="FileSave" visible="false"/>
<button idMso="ConvertDatabaseForm at" visible="false"/>
<button idMso="FileSaveAsMenuAcces s" visible="false"/>
<button idMso="FileManageMenu" visible="false"/>
<button idMso="FileSendAsAttachmen t" visible="false"/>
<button idMso="MenuPublish" visible="false"/>
<button idMso="FileServerMenu" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
</backstage>
<backstage>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="SourceControlCreate
<button idMso="FileOpenDatabase" visible="false"/>
<button idMso="FileSave" visible="false"/>
<button idMso="ConvertDatabaseForm
<button idMso="FileSaveAsMenuAcces
<button idMso="FileManageMenu" visible="false"/>
<button idMso="FileSendAsAttachmen
<button idMso="MenuPublish" visible="false"/>
<button idMso="FileServerMenu" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
</backstage>
or maybe
<backstage>
<control idMso="FileNewDatabase" visible="false"/>
<control idMso="SourceControlCreate DatabaseFr omProject" visible="false"/>
<control idMso="FileOpenDatabase" visible="false"/>
<control idMso="FileSave" visible="false"/>
<control idMso="ConvertDatabaseForm at" visible="false"/>
<control idMso="FileSaveAsMenuAcces s" visible="false"/>
<control idMso="FileManageMenu" visible="false"/>
<control idMso="FileSendAsAttachmen t" visible="false"/>
<control idMso="MenuPublish" visible="false"/>
<control idMso="FileServerMenu" visible="false"/>
<control idMso="FileCloseDatabase" visible="false"/>
</backstage>
<backstage>
<control idMso="FileNewDatabase" visible="false"/>
<control idMso="SourceControlCreate
<control idMso="FileOpenDatabase" visible="false"/>
<control idMso="FileSave" visible="false"/>
<control idMso="ConvertDatabaseForm
<control idMso="FileSaveAsMenuAcces
<control idMso="FileManageMenu" visible="false"/>
<control idMso="FileSendAsAttachmen
<control idMso="MenuPublish" visible="false"/>
<control idMso="FileServerMenu" visible="false"/>
<control idMso="FileCloseDatabase" visible="false"/>
</backstage>
ASKER
I tried that. Got errors on these lines: SourceControl CreateDatabaseFromProject, ConvertDatabaseFormat, MenuPublish.. I think those names have changed in 2010.
get rid of thoes two lines. are the others gone?
which one are you using <control idMso or <button idMso?
which one are you using <control idMso or <button idMso?
when i get rid of the code i only have a few options new open and close database. so maybe some of that code is not needed anyway.
try just using
FileNewDatabase" FileOpenDatabase" FileCloseDatabase"
try just using
FileNewDatabase" FileOpenDatabase" FileCloseDatabase"
worked on my end
ASKER
Tried:
<control idMso="FileNewDatabase" visible="false"/>
<control idMso="FileOpenDatabase" visible="false"/>
<control idMso="FileCloseDatabase" visible="false"/>
I think is doesn't like Control idMso. I get an error on each of these lines...
No error on <button idMso="FileCloseDatabase" visible="false"/>
<control idMso="FileNewDatabase" visible="false"/>
<control idMso="FileOpenDatabase" visible="false"/>
<control idMso="FileCloseDatabase" visible="false"/>
I think is doesn't like Control idMso. I get an error on each of these lines...
No error on <button idMso="FileCloseDatabase" visible="false"/>
so this?
<backstage>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="FileOpenDatabase" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
</backstage>
<backstage>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="FileOpenDatabase" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
</backstage>
ASKER
The only backstage command I have in there is : <button idMso="FileCloseDatabase" visible="false"/>
When I click on the File tab I still see "Close Database." along with all of the other stuff.
Here it is:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<tabs>
<tab id="MyTab1" label="My Tab 1">
</tab>
</tabs>
</ribbon>
<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
</backstage>
</customUI>
When I click on the File tab I still see "Close Database." along with all of the other stuff.
Here it is:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="true">
<tabs>
<tab id="MyTab1" label="My Tab 1">
</tab>
</tabs>
</ribbon>
<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
</backstage>
</customUI>
looks like you might have already had it. i just didnt realize you did.
<backstage>
<button idMso="FileSave" visible="false"/>
<button idMso="FileSaveAs" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileClose" visible="false"/>
<button idMso="ApplicationOptionsD ialog" visible="false"/>
<button idMso="FileExit" visible="false"/>
<tab idMso="TabInfo" 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"/>
</backstage>
<backstage>
<button idMso="FileSave" visible="false"/>
<button idMso="FileSaveAs" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileClose" visible="false"/>
<button idMso="ApplicationOptionsD
<button idMso="FileExit" visible="false"/>
<tab idMso="TabInfo" 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"/>
</backstage>
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
yes that does make sense. a custom xml ribbon in my environment doesn’t appear until runtime. glad you figured it out! also thanks for posting what you found out as i am sure i will be switching to 2010 soon.
: )
: )
"Donna'
fyi only ... your EE icon shows a male :-)
So, in summary ... which post Hides the File tab ... while retaining any custom menus from A2003 on the Add-In ribbon ...?
mx
fyi only ... your EE icon shows a male :-)
So, in summary ... which post Hides the File tab ... while retaining any custom menus from A2003 on the Add-In ribbon ...?
mx
in summary the only way to hide the file tab is to hide the entire ribbon.
ASKER
Hi DatabaseMX,
This is what hides the file tab:
<backstage>
<button idMso="FileSave" visible="false"/>
<button idMso="FileSaveAs" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileClose" visible="false"/>
<button idMso="ApplicationOptionsD ialog" visible="false"/>
<button idMso="FileExit" visible="false"/>
<tab idMso="TabInfo" 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"/>
</backstage>
also added code to hide the "Recent db"
see this:
http://www.accessribbon.de/en/index.php?FAQ:FAQ_Access_2010:2
Thanks for the EE icon tip!
Donna
This is what hides the file tab:
<backstage>
<button idMso="FileSave" visible="false"/>
<button idMso="FileSaveAs" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileClose" visible="false"/>
<button idMso="ApplicationOptionsD
<button idMso="FileExit" visible="false"/>
<tab idMso="TabInfo" 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"/>
</backstage>
also added code to hide the "Recent db"
see this:
http://www.accessribbon.de/en/index.php?FAQ:FAQ_Access_2010:2
Thanks for the EE icon tip!
Donna
ASKER
conagraman is correct.
What the code does is hide what is in the File tab. But you still see the "FIle" tab.
I put a Close Program button on that tab... So, that is all you see in there!
Hope that clears things up!
Donna
What the code does is hide what is in the File tab. But you still see the "FIle" tab.
I put a Close Program button on that tab... So, that is all you see in there!
Hope that clears things up!
Donna
Would you be able to post a screen shot of the 'ribbon' are (top of app) that shows the end result?
thx.mx
thx.mx
i can’t show you 2010 but see my post 34122170 to see 2007. I’m sure the result is similar.
ASKER
So, I'm slightly confused. The File tab is still there? And if you click it, does all of the stuff underneath appear ?
And you created the Close and Help items ?
mx
And you created the Close and Help items ?
mx
ASKER
Yes, the file tab is still there.. If you click on it the only thing you see is the "Return to Main Menu" button. Yes, I created the Close and Help tabs. They have things that are needed for this specific program.
The file tab is the system generated one that you can't hide without totally hiding all Ribbon Bars.
So, the solutions is to hide all of the contents in the File tab (hide the Save db, Options, Print, Recent db, etc...) I put the "Return to Main Menu" button in the File Tab. So what ever screen they are in at the time they can click on the "FIle" tab and then click on "Return to Main Menu" button to get back to the Main Menu Screen of the program.
The file tab is the system generated one that you can't hide without totally hiding all Ribbon Bars.
So, the solutions is to hide all of the contents in the File tab (hide the Save db, Options, Print, Recent db, etc...) I put the "Return to Main Menu" button in the File Tab. So what ever screen they are in at the time they can click on the "FIle" tab and then click on "Return to Main Menu" button to get back to the Main Menu Screen of the program.
I see. So, I'm wondering if ... I had an A2003 custom menu, that would appear on the Add-In Ribbon ... if I 'hide' the File tab in this context, will I see the File tab + my custom menu (via the Add-In ribbon) ... say in place of your Close & Help items ..?
Also, did you use the http://www.accessribbon.de/en/ tool to create all of this ?
thx.mx
Also, did you use the http://www.accessribbon.de/en/ tool to create all of this ?
thx.mx
ASKER
I'm not sure about that?!!? Haven't tried that.
I converted my Custom Menus/toolbars to the XML code...
I converted my Custom Menus/toolbars to the XML code...
" I converted my Custom Menus/toolbars to the XML code..."
Meaning you recreated them in XML ... or used some conversion tool?
The reason I'm asking these questions is I will be doing this shortly on many mdb's here at work. I just got an A2010 workstation set up yesterday ... to start testing A2003 apps on. Not converting to ACCDB, but they need to run in the A2010 environment.
mx
Meaning you recreated them in XML ... or used some conversion tool?
The reason I'm asking these questions is I will be doing this shortly on many mdb's here at work. I just got an A2010 workstation set up yesterday ... to start testing A2003 apps on. Not converting to ACCDB, but they need to run in the A2010 environment.
mx
btw ... close the Q anytime you like ... no pts for me, these are just academic questions ... lingering on lol.
mx
mx
ASKER
No, I didn't use a conversion tool. Found stuff on the internet to help me create the code.
This is a good site to use:
Access Ribbon Website called Avenius Gunter
<http://www.accessribbon.de/en/index.php?Welcome>
We are moving to Office 2010 and I have many db's to convert. I'm converting to ACCDB. Why are you staying with the mdb format?
This is a good site to use:
Access Ribbon Website called Avenius Gunter
<http://www.accessribbon.de/en/index.php?Welcome>
We are moving to Office 2010 and I have many db's to convert. I'm converting to ACCDB. Why are you staying with the mdb format?
Not converting at this time because O2010 deployment to all work stations will not be simultaneous ... and not starting until Dec or Jan. So, the apps will have to work in both environments for a period of time. Down the road next year, I will mostly likely convert ... once everything is 'stable'.
mx
mx
ASKER
I didn't realize I had to run the program from scratch to see that the <backstage> code I had worked....
https://www.experts-exchange.com/questions/26604173/Can-I-hide-the-File-Tab-or-limit-the-functions-on-it.html?cid=1573&anchorAnswerId=34099679#a34099679
mx