Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old August 13th, 2004, 03:14 PM
stnelson stnelson is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Posts: 5 stnelson User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 m 24 sec
Reputation Power: 0
Menus/Toolbars Missing

I saved a database and altered the menu bars by accident where now the only bar at the top is the very basic bar. Unfortunately, when the database opens it goes to my switchboard. I need to continue to make changes to the design of the database but am unable to open up the table/query/form/report shortcut toolbar. Any way of bringin back the toolbars?

Reply With Quote
  #2  
Old August 13th, 2004, 05:27 PM
ineuw ineuw is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 82 ineuw User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 30 m 28 sec
Reputation Power: 5
Most ceitainly Click on Customize and go to the Toolbars tab and select the desired Menu/Toolbars and also check its display options. Do this also on the database Startup properties under Allow . . . etc.

If that fails, create an Autoexec macro (everyone should have one) and select the ShowToolbar command for each toolbar you wish always to see (or hide). There is a dropdown list for all built in toolbars. Finally, you can also accomplish it in VBA by calling a public function with:

DoCmd.ShowToolbar "Menu Bar", acToolbarYes ... or with any toolbar name in the quotes.

(I assume you're working with Access XP)

Reply With Quote
  #3  
Old August 16th, 2004, 01:53 PM
stnelson stnelson is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Posts: 5 stnelson User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 m 24 sec
Reputation Power: 0
Still need toolbar help!

Quote:
Originally Posted by ineuw
Most ceitainly Click on Customize and go to the Toolbars tab and select the desired Menu/Toolbars and also check its display options. Do this also on the database Startup properties under Allow . . . etc.

If that fails, create an Autoexec macro (everyone should have one) and select the ShowToolbar command for each toolbar you wish always to see (or hide). There is a dropdown list for all built in toolbars. Finally, you can also accomplish it in VBA by calling a public function with:

DoCmd.ShowToolbar "Menu Bar", acToolbarYes ... or with any toolbar name in the quotes.

(I assume you're working with Access XP)


Thanks for the suggestions! Unfortunately none of them worked. I have attached a document showing what toolbar menu I have and what each of them allows me to see. I still cannot, even with a "showmenu" macro bring up the normal toolbars. HELP!
Attached Images
File Type: jpg toolbar.jpg (26.7 KB, 579 views)

Reply With Quote
  #4  
Old August 16th, 2004, 05:18 PM
ineuw ineuw is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 82 ineuw User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 30 m 28 sec
Reputation Power: 5
You picture speaks 1000 words and what I see is the standard Access menu bar of the database window. It would help to know which version of Access you're using which toolbar, and in which view are you missing (Forms?, Form desgn?, Report? Preview?, Report design view, etc). Toolbars are part of MS Office and your options are in ascending order:

In the references select the Microsoft Office library, 9 orr 10 whichever is in the list and move its priority up to the top as possible.

Create a new database and see if you have the menu bars you're looking for. If so, import your objects from the possibly corrupt db.

Run a reinstall to repair your application, and at the least, be sure to include EVERYTHING that relates to Access. This includes all the tools, and have them all run from the drive.

Please let me know and I will try to find some answers. If I do, will let you know.

Reply With Quote
  #5  
Old August 19th, 2004, 07:10 PM
stillkarenann stillkarenann is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Posts: 2 stillkarenann User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Toolbar/Menu recovery

I literally just figured this out for myself when I stumbled across yours...

~ Close out Access
~ Press and hold the 'Shift' key while doubleclicking on your database
~ (optional depending on the db) Click Run
~ Go to Tools -> Startup
~ Check all those stupid checkboxes and hit OK.
~ Save!

When you're done programming, you can uncheck those boxes to protect lusers from messing up your work. (Don't tell em your shift hack

Hope this helps!!!

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Menus/Toolbars Missing


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT