Eabling Disabling menus etc

[pikou]

Hello i would like to ask if there is any way for me to enable the menus , the menu bar and the database window if i disable them from the startup options of my Db ?

 

[skea]

You must have screwed up Your Access.
If you are the type who doesnt like the Access Menu Bar and ToolBar like me, you Will have to run into this quite often. More so during development.
I Developed my self a Menu Bar and Toolbar resetter which resets my Menus and Toolbars in case my Access is screwed up.
If you need to turn then on and off in the course of your database Navigation then I recomend this thread
Attached Is the Resetter

 

[pikou]

Thx a lot very good work.
Oh and yeah i kinda screwed my acess up heehe

 

[skea]

Glad to be of help.

 

[pikou]

Well it was all going well until i tried to run the form and got the message to reset my toolbars.I answered OK but it dooe nothing and i noticed that the title of the MsgBox is "The application cannot find the toolbar Visual Basic" and then nothing everything is as it was before.
Any thoughts on that ?

 

[skea]

If you go to Module1 and comment out
DoCmd.ShowToolbar "Visual Basic", acToolbarWhereApprop
the caption wont appear again.

But after the form loading. It should display the most needed of access toolbars.
If you close and you press shift and click on you db. it should be able to open.
Dont forget to go and tick those options in the startup dialog, but if you are disabling your startup options through code, its best you post it so that you can be helped further.

 

[pikou]

I have actually disabled the menus from the startup options so maybe that has something to do with this ?
If so what can i do to re-enable them ?

 

[skea]

But pikou, even if you unchecked every thing in the startup options. There would be no problem. Press the shift key and Click to open your DB, then try to put a startup form(Display Form/Page).
Or post some thing small.

 

[pikou]

That is the problem.The tools -> startup options menu is not there anymore.That is my main problem cause i can enable the db window from a button i have but cant alter tha startup options.Plus all tha right click mouse menus do not work either.

 

[skea]

Is your Menu Bar There? If not then Behind that command button, try this.

Application.CommandBars("Menu Bar").Enabled = True
DoCmd.ShowToolbar "Menu Bar", acToolbarYes

Dim i As Integer
For i = 1 To Application.CommandBars("Menu Bar").Controls.Count
 Application.CommandBars("Menu Bar").Controls(i).Enabled = True
 Application.CommandBars("Menu Bar").Controls(i).Visible = True
Next i

If if it does not work out, try run your db on another machine just to check whether your Access is still screwed up. If its true then use the resetter.
If its not true then, please scrap out the unnecessary and post your form that has that button.