?
Solved

Reinstating Allow full menu

Posted on 2008-10-08
6
Medium Priority
?
550 Views
Last Modified: 2013-11-29
I believe that it must be possible to reinstate Allow full menu after you've tick it of through tool>Startup.

Can someone please tell me how to do this.
0
Comment
Question by:Sheils
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1800 total points
ID: 22668008
hold the shift key while opening the db.
0
 
LVL 10

Assisted Solution

by:therealmongoose
therealmongoose earned 200 total points
ID: 22669056
Alternatively you can show all menus with this code:
Sub showall()
 
Dim i As Integer
 
For i = 1 To CommandBars.Count
 
    CommandBars(i).Enabled = True
    
Next i
 
End Sub

Open in new window

0
 
LVL 16

Author Comment

by:Sheils
ID: 22672541
Capricorn: You're solution definitely works. I am going to awared you the points. However, I need some clarification from therealmongooose to see if the points should be shared.

Theremongoose how is the code triggered. I don't want the full menu to be available everytime the db opens, just when the db developer is opening it for maintenance
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22672598
before you can place those codes,

 you have to open the db while holding the Shift key...
0
 
LVL 16

Author Comment

by:Sheils
ID: 22672889
So I take it that the purpose of this code is to prevent the disabling of the full menu. And that it cannot be used to reinstate the full menu if it is already diabled.

As I said capricorn I just need a little clafication on when and how to use this code. However, the shift option seems so straight forward I can hardly see why I'd need the code.

I am guessing that it maybe useful  if another code could be used to stop the shift option from working. Then the showall code can be linked to an event such as a logon form so that gives the option of opening the database as user, administrator or developer.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22672940
(Then the showall code can be linked to an event such as a logon form so that gives the option of opening the database as user, administrator or developer.)

this is more like it
0

Featured Post

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!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

649 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