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

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -