Solved

Removing Custom Toolbar from Add-ins tab in Access 2010

Posted on 2011-03-14
13
1,415 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
 
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 119

Expert Comment

by:Rey Obrero
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now