HI,
I want to customize my access database. I don't want to view Ribbon only on certain db.
HI,
I want to customize my access database. I don't want to view Ribbon only on certain db.
Start with: Click the Office button > Options > Current Database > set options as desired.
Hold down the shift key when you open database and most of the optional settings will be overridden and you can modify design.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
You can also add a blank ribbon to your USysRibbons table and select it as the default ribbon.
Create a new row, give it a name, and put this in the RibbonXML field.
Then you can go into your database options and select it as your ribbon.<!-- This is used in the startup to remove the ribbon and limit options in the Office menu --><customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
<ribbon startFromScratch="true">
<officeMenu>
<button idMso="FileNewDatabase" visible="false"/>
<button idMso="FileOpenDatabase" visible="false"/>
</officeMenu>
</ribbon>
</customUI>
I don't find option for my requirement.I don't want to view Ribbon only on certain db
To make the ribbon not visible: in the OnLoad event of the first form to open type in: docmd.showToolbar
as you type it the intellisense will offer that option ; you name the ribbon (which ironically is "ribbon") and then select yes or no (in your case No) which will be offered as a choice
so you have: docmd.showToolbar "Ribbon", acToolbarNo
Thanks buddy. It's working
Hi,
1. If i don,t want to view Home Tab of ribbon then what code i have to place?
Thanks
Review:
http://office.microsoft.com/en-us/ac...010211415.aspx
http://www.accessribbon.de/en/
This the code I use in the USysRibbons table:
Code:<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad" > <commands> <command idMso="Help" enabled="false"/> </commands> <ribbon startFromScratch="true"> <officeMenu> <button idMso="FileOpenDatabase" visible="false"/> <button idMso="FileNewDatabase" visible="false"/> <button idMso="FileCloseDatabase" visible="false"/> </officeMenu> <qat> <documentControls> <button idMso="DataRefreshAll"/> </documentControls> </qat> </ribbon> </customUI>
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.