Getting back theToolbars

[camelk]

When I finished by db I went to startup and took off all the toolbars. Now I need them back to so that I can continue to work on the db. How do I find/access them?

 

[FancyPrairie]

Trying to duplicate your problem, I too lost my menu bar and tool bar. I'm assuming you still have a menu bar, of some kind, displayed. If so, right click on the menubar (or toolbar) and select Customize. Then select the tab entitled "Commands". Under Categories, select Tools. On the right side, scroll down until you see Startup... Drag Startup... to your menubar (or toolbar if shown). Then close the customize window and select Startup... and select the choices you deselected. Then exit and Access and restart it. That should take care of it.

 

[camelk]

FancyPraire: I opened my db and right clicked on what was left of my menu and tool bar but nothing happened. Do you have any other suggestions. Thanks Camelk

 

[AvGuy]

See the Help topic on ShowToolbar Method. Write an event procedure using this function to hide or display toolbars and menubars. For example, you can display a custom toolbar when a report is opened and then hide it when the report is closed.

Access has certain defaults for displaying and hiding tool/menu bars, but there are bugs in the routines and you will find that exercising manual control over this part of the application will be to your advantage.

Cheers,
Uncle Jack

 

[camelk]

AvGuy
Sorry, but your suggestion is way over my head. Isn't there a simple way to get back my default toolbars and menus after removing them from the db?
camelk

 

[AvGuy]

It depends on whether you're attempting to hide/show tool/menu bars programmatically or from the database window. If from the database window there's a VIEW button that might do it as suggested previously. If not you can try recycling the global command. Open Tools-Startup then clear the "Allow Built-in Toolbars" box. Quit the application and Access. Then restart, and then check the "Allow Built-in Toolbars" box, close and restart Access and see if they don't come back.

If trying to reset programatically, use an event procedure.
Suppose you want to display a custom toolbar for a report. In the Event Properties for the report, under the Open Report Event place this code:

DoCmd.ShowToolbar "ReportToolbar", acToolbarYes

and in the On Close event place the corollary

DoCmd.ShowToolbar "ReportToolbar", acToolbarNo

You can substitute the name of a built in toolbar as well.

 

[BillPower]

Hi camelk,

In your position I would try creating a new database and import all the Objects from the DB that you have removed the Menus from. When you open the new DB, you should have your Menus back.

For an Access 2000 DB (97 is almost the same) to do the above:

1. Launch Access

2. From the Menu select File-> General Tab-> Database, Save it as whatever.

3. After Saving, again from the Menu select File-> Get External Data-> Import. From the Import Dialog Box find your existing DB, Double click on it.

4. From the Import Objects window that should now be visible, click on each Tab from Tables through to Modules clickin Select All on each Page. Finally Click OK.

You should have all your tables, forms etc in the new DB that are in the Menuless DB.

Hope this does the trick.