Solved

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

Posted on 2012-03-09
6
574 Views
Last Modified: 2012-03-09
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
Comment
Question by:filtrationproducts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 150 total points
ID: 37703109
In vba


Commandbars("youcommandbar").visible = true
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 350 total points
ID: 37703110
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
 
LVL 1

Author Comment

by:filtrationproducts
ID: 37703154
I tried it but i get the following error;

Runtime Error 5
invalid procedure call or argument
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Author Comment

by:filtrationproducts
ID: 37703162
Wait that worked!
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37703163
What the name of your custom commandbar menu?
0
 
LVL 75
ID: 37703176
Twice within 2 hours - almost same situation came up, with same solution.

mx
0

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question