Solved

Removing Custom Toolbar from Add-ins tab in Access 2010

Posted on 2011-03-14
13
1,448 Views
Last Modified: 2012-05-11
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
Comment
Question by:MnInShdw
13 Comments
 
LVL 75
ID: 35133762
Just curious as to why you would want to -if they are your custom menus?

mx
0
 
LVL 75
ID: 35133821
Uncheck the Show Tab - right click over Add-Ins ... see image

mx
Capture1.gif
0
 
LVL 1

Author Comment

by:MnInShdw
ID: 35134090
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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 75
ID: 35134124
"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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35134148
the easiest way is, in Access 2003,  remove the customized tool bars before converting/upgrading  to A2010
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 35134291
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
 
LVL 1

Author Comment

by:MnInShdw
ID: 35134414
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
 
LVL 1

Author Closing Comment

by:MnInShdw
ID: 35134426
Million thanks
0
 
LVL 75
ID: 35134468
"I've actually removed Option from File tab."
Curious how you did that ...?

mx
0
 
LVL 1

Author Comment

by:MnInShdw
ID: 35134752

<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
 
LVL 1

Author Comment

by:MnInShdw
ID: 35134823
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
 
LVL 1

Author Comment

by:MnInShdw
ID: 35134833
0
 
LVL 1

Author Comment

by:MnInShdw
ID: 35134840
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question