• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 608
  • Last Modified:

Clicked X on custom toolbar in Access 2007 - cannot get it back

I have a database with a toolbar menu that was created in Access 2003. A user clicked and dragged the menu off of the top part of the window then clicked X to close it. I cannot figure out how to get the menu back on their machine.

The menu bar is a 2003 style, and incorperated within 2007.

I attached some images to show how it was removed from the screen.

Thanks for the help ahead of time!

Dan
CUSTOMMENUIMAGES.png
0
filtrationproducts
Asked:
filtrationproducts
  • 2
  • 2
  • 2
2 Solutions
 
mbizupCommented:
In vba


Commandbars("youcommandbar").visible = true
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Put these two lines of code in a VBA Function, then call that function from the VBA Immediate window.

   CommandBars("YourMenuBarName").Enabled = True
   CommandBars("YourMenuBarName").Visible = True

mx
0
 
filtrationproductsAuthor Commented:
I tried it but i get the following error;

Runtime Error 5
invalid procedure call or argument
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
filtrationproductsAuthor Commented:
Wait that worked!
0
 
mbizupCommented:
What the name of your custom commandbar menu?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Twice within 2 hours - almost same situation came up, with same solution.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

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