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

java - WARN : org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/board/] in DispatcherServlet with name 'appServlet' -

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

android - How to create dynamically Fragment pager adapter -