Solved

Reinstating Allow full menu

Posted on 2008-10-08
6
537 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
  • 3
  • 2
6 Comments
 
LVL 119

Accepted Solution

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

Assisted Solution

by:therealmongoose
therealmongoose earned 50 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 119

Expert Comment

by:Rey Obrero
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 119

Expert Comment

by:Rey Obrero
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

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

895 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

18 Experts available now in Live!

Get 1:1 Help Now