• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

Reinstating Allow full menu

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
Sheils
Asked:
Sheils
  • 3
  • 2
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
hold the shift key while opening the db.
0
 
therealmongooseCommented:
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
 
SheilsAuthor Commented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Rey Obrero (Capricorn1)Commented:
before you can place those codes,

 you have to open the db while holding the Shift key...
0
 
SheilsAuthor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
(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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now