Solved

Reinstating Allow full menu

Posted on 2008-10-08
6
539 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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.
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

792 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