ms access - MSAccess2010 - show only Add-Ins Tabs -
my ms access apps load commandbar object @ startup in add-ins tab. hide others msacces tab. how?
here code use show commandbar.
application.commandbars("bamp_wa_main_toolbar").visible = true application.commandbars("bamp_wa_main_toolbar").position = msobartop
the following code found on web hide tabs including add-ins.
docmd.showtoolbar "ribbon", actoolbarno
you need add table database called usysribbons 3 fields - id (autonumber), ribbonname (text) , ribbonxml (memo).
add record table , add "mymenu" ribbonname field. in ribbonxml field add;
<customui xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon startfromscratch="true"> <tabs> <tab idmso="tabhomeaccess" visible="true" /> <tab idmso="tabcreate" visible="false" /> <tab idmso="tabexternaldata" visible="false" /> <tab idmso="tabdatabasetools" visible="false" /> <tab idmso="tabsourcecontrol" visible="false" /> <tab idmso="tabaddins" visible="true" /> </tabs> </ribbon>
restart database , go access options , select 'mymenu' ribbon name list in ribbon , toolbar options.
restart again , tabs should hidden apart 'addins'.
Comments
Post a Comment