Disabled built in toolbars 1

[TRUCK0321]

I disabled my built in toolbars at the start-up dialogue and cannot get in to change them back. The only toolbar I have is a custom one that lets me go to design mode. I can design forms and write code but I don't know how to get the built in toolbars back. Does anyone have any suggestions?

 

[vb6novice]

Truck0321,

I'm sure you are not the only one that has found yourself in this situation. The way out is not too difficult.

Open you database holding down th shift key. Create a new module. Insert the code below in the module, then run the module.

Sub get_my_tool_bars_back(Cancel As Integer)

DoCmd.ShowToolbar "Database", acToolbarYes
DoCmd.ShowToolbar "Menu Bar", acToolbarYes
DoCmd.ShowToolbar "Form View", acToolbarYes
DoCmd.ShowToolbar "Form Design", acToolbarYes

End Sub

I found a that good way around this problem is to hide the toolbars during the open event of the main form (not using the start-up dialog box), and then showing them again when when I close the main form. It's a little bit of a pain when your are debugging a program because when execution stops on an error and shows the code, the toolbars are hidden. I get around that by putting a label on my main form (which is always open) that users cannot see (it's enabled, just not visible). Clicking that label runs the code to close the main form and restore the toolbars. You just might have to remember where you were in the code to do your debug.

Hope this helps.

 

[TRUCK0321]

That did the trick, thanks alot!