469,271 Members | 1,776 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

How to disable the home menu in access 2007

I have an access database in (access 2007) that I want to package. Now i want to disable the home menu before I package it. please help me
Jun 29 '11 #1
6 8625
Adam Tippelt
137 100+
Click the Office button in the top left corner, then in the bottom right corner of the drop down menu should be an "Access Options" button. Click this to bring up the properties. Select the Current Database tab, scroll down to Ribbon and Toolbar Options and untick Allow Full Menus and Allow Default Shortcut Menus.

You might also want to consider hiding the Document Tabs and disabling the Access Special Keys (in the Application Options area of Current Database).

Hope that helps.

Adam.
Jun 29 '11 #2
I tried the approach below but the home menu in access 2007 did not disable. help me dis able it.

Click the Office button in the top right corner, then in the bottom right corner of the drop down menu should be an "Access Options" button. Click this to bring up the properties. Select the Current Database tab, scroll down to Ribbon and Toolbar Options and untick Allow Full Menus and Allow Default Shortcut Menus.
Jun 29 '11 #3
Adam Tippelt
137 100+
Are you aware that the database must be closed and reopened for the changes to take effect?

The home menu will not be completely disabled, however it will have 90% of the options removed, so the only option left is to close the application.
Jun 29 '11 #4
Wornout
22
If you right click on the home tool bar and minimize it you will only see the word home
Dec 1 '13 #5
ADezii
8,800 Expert 8TB
It appears as if you wish to create a Custom Ribbon with no Groups. If this is so, then:
  1. Open the System USysRibbons Table.
  2. In the [RibbonName] Field enter rbnSimplest.
  3. In The RibbonXML Field enter:
    Expand|Select|Wrap|Line Numbers
    1. <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    2.   <ribbon startFromScratch="true">
    3.   </ribbon>
    4. </customUI>
    5.  
  4. If you wish, enter a Description for this Ribbon in the Description Field.
  5. Close and Save the Table USysRibbons.
  6. Click on the Microsoft Office Button ==> Current Database ==> Ribbon and Toolbar Options ==> Set Ribbon Name to rbnSimplest.
  7. Save the change, exit the Database, then reopen.
  8. You should now have the simplest Ribbon of all consisting of no Groups.
Dec 2 '13 #6
Mandir
1
Tried it but still the Menu comes up and have to press Shift key before opening the database in MS Access 2007>


@Adam Tippelt
Nov 15 '14 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

27 posts views Thread by Wayne | last post: by
2 posts views Thread by bobdydd | last post: by
4 posts views Thread by lupo666 | last post: by
2 posts views Thread by D Hammer - Sayner | last post: by
9 posts views Thread by prakashwadhwani | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.