473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Reseting menu bar with VBA in Access?

Hi!

What's the proper Visual Basic for Applications (VBA) code for reseting
the menu bar and the tool bar in Access.

Thanks in advance,
Markus

Nov 13 '05 #1
1 1516
On 1 Jun 2005 01:10:47 -0700, wa********@yahoo.com wrote:
Hi!

What's the proper Visual Basic for Applications (VBA) code for reseting
the menu bar and the tool bar in Access.

Thanks in advance,
Markus

Hi
CommandBars("Menu").Reset
replacing Menu with the toobar's name.

Quoting from the access97 help file
"Once you establish a reference to the CommandBars collection object,
you can access all the properties and methods of the object. You can
set a reference to the CommandBars collection object by clicking
References on the Tools menu while in module Design view. Set a
reference to the Microsoft Office 8.0 Object Library in the References
dialog box by selecting the appropriate check box."

There may be changes for later versions of Access.
David

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Steven | last post by:
I have some text boxes on a form in MS Access 2000. When I right click in them I don't get any shortcut menu at all. I want the normal cut, copy, and past menu to come up. In the "Startup", I...
7
by: Ian Hinson | last post by:
I have an Access app that has been distributed with run-time installation to many different customers over many years. It is developed in Access 2000. The custom menu bar has had no problems in...
1
by: ward | last post by:
Good morning everyone. I'm building a very simple content management site that tracks "tasks." The options available are: 1. Add Task 2. Edit Task 3. View Task 4. Print Task
27
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same...
2
by: Tim Marshall | last post by:
I'm trying to have a menu item in a custom menu that serves the same purpose as the standard Windows built in menu with respect to the list of forms that are open. However, I don't want to let the...
2
by: Mark G. King | last post by:
I have Access 2003 SP2. When I open any database annd choose Tools / Database Utilities the menu item Compact And Repair is missing. I have re-installed Office 2003 using Detect and Repair but...
4
by: Adam Rosner | last post by:
I have a large Access application that I look after. This app is written in Access 2000 and uses menu bars. (CommandBars and CommandBar Controls). The menu is static - built into the app (ie...
4
by: lamkelf | last post by:
Hi all, I have found solution for previous Access versions (i.e. compacting database) but it doesn't work with the 2003 version. Can someone point me to a website or give me some hints. ...
3
by: ApexData | last post by:
Access2k non runtime. In a previous post, I mentioned that I wanted to hide the Access 'Menu Bar' from view. That means that I DO NOT want to be able to see the MenuBar, even as a momentary...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.