[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1664
  • Last Modified:

Removing Custom Toolbar from Add-ins tab in Access 2010

I had a Microsoft Access 2003 Application with custom menu bar - tool bar & context menu.
They were created via UI in Access 2003 (right clicking hte menu and selecting Customize)

After upgrading this database to Access 2010, the menubar and toolbar is added to Add-Ins Tab.
How can I remove them?

thank you.
0
MnInShdw
Asked:
MnInShdw
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Just curious as to why you would want to -if they are your custom menus?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Uncheck the Show Tab - right click over Add-Ins ... see image

mx
Capture1.gif
0
 
MnInShdwAuthor Commented:
They're not my custom menu and toolbar anymore.
After upgrading this access file, I have removed Access Ribbon and added my own customized ribbon.
See the image bellow.

Your solution hides them not removing them.
If they are hidden and not removed, any user of the application can check this option to show them again ,
which clicking them may show some errors (the macro doesn't exist) or may cause other problems.

many thanks for any other suggestion.

 Ribbon
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"If they are hidden and not removed, any user of the application can check this option to show them again "

Well ... not sure you can remove it. Should be a way.  But re:

"If they are hidden and not removed, any user of the application can check this option to show them again "

If you hide the File tab, then user cannot get to those options ...

mx
0
 
Rey Obrero (Capricorn1)Commented:
the easiest way is, in Access 2003,  remove the customized tool bars before converting/upgrading  to A2010
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
It is possible too use DAO to work with the old command bars.

You can also try this to delete one:

Application.CommandBars("My Toolbar").Delete
0
 
MnInShdwAuthor Commented:
DatabaseMX
I've actually removed Option from File tab.
and have used  ChangeProperty "AllowBypassKey", 1, False to bypass shift+double click on the file.

But you know there's a lot of ways to open it normally.
The users don't bother to go VB and play with it, because they know it's not their section.
But when there's a menu and a toolbar with familiar titles, they may try it.


capricorn1
I wish I had done it. But now that I'm on 2010, I'm not able to save it as a mdb file. I'm receiving an error telling me that the database is using some properties that prevent saving it as a 2000-2002 version.


TheHiTechCoach
Million thanks. It did the magic.
0
 
MnInShdwAuthor Commented:
Million thanks
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"I've actually removed Option from File tab."
Curious how you did that ...?

mx
0
 
MnInShdwAuthor Commented:

<backstage>
     <button idMso="FileSave" visible="false"/>
   <button idMso="SaveObjectAs" visible="false"/>
   <button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
   <button idMso="FileOpen" visible="false"/>
   <button idMso="FileCloseDatabase" 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"/>
   <button idMso="ApplicationOptionsDialog" visible="false"/>
   <button idMso="FileExit" visible="false"/>
  </backstage>

Open in new window

0
 
MnInShdwAuthor Commented:
Sorry, I forgot to add the explanation.

The line <button idMso="ApplicationOptionsDialog" visible="false"/> will hide options


You need to add a table UsysRibbons table.
If you need detailed
0
 
MnInShdwAuthor Commented:
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now