By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,299 Members | 1,210 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,299 IT Pros & Developers. It's quick & easy.

Reseting menu bar with VBA in Access?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.