Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling Menu Bar options

Status
Not open for further replies.
legendv

legendv

Technical User
Apr 10, 2002
32
0
0
US
I want a cmd button on a form that lets the user "compact and Repair" the database.
The menu's have been removed.
There is a hidden menu, called "Developer" which is only accessible thru a password protected form, that has the menu option "Compact and Repair Database..."

Here's what I have: (in a module)

Public Sub CompactDB()
Commandbars("Developer").Controls("Compact and Repair Database...").accDoDefaultAction
End Sub

The menubar is labeled Developer and Compactandrepairdatabase is listed in the first pull down

Any suggestions?
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Trying to programmatically select Navigation Options in Access Options
Replies
4
Views
99
combo
combo
patriciaxxx
  • Locked
  • Question
ms access 2003 disable / enable greyed out menu options in mde database window
Replies
4
Views
120
patriciaxxx
patriciaxxx
03Explorer
  • Locked
  • Question
MS Access VBA new Module subroutine calling excel file that is opened by Form Subroutine 1
Replies
4
Views
36
03Explorer
03Explorer
08211987
  • Locked
  • Question
Access calling Excel macro "Run-time error '9': Subscript out of range" 1
Replies
5
Views
62
SkipVought
S
Darrylles
  • Locked
  • Question
External application closes due to calling code scope 1
Replies
2
Views
36
Darrylles
Darrylles

Part and Inventory Search

Sponsor

Back
Top