• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • 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
Independent Software Vendors: 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!

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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