Hi.
I need to add-in a
few commands like Filter and Sort for the user, how to switch off the Allow
Full Menu while still have my customize menu? Or how to create a customize
menu bar?
See the following Web pages for step-by-step instructions on how to create a
custom menu:
Create a custom menu bar:
http://msdn.microsoft.com/library/d...chowCreateCustomMenuBarForCurrentDatabase.asp
Add custom menus to menu bar:
http://msdn.microsoft.com/library/d.../en-us/off2000/html/ofdccCreateCustomMenu.asp
Add a built-in menu:
http://msdn.microsoft.com/library/d...y/en-us/off2000/html/ofdccAddOrDeleteMenu.asp
Add commands:
http://msdn.microsoft.com/library/d.../en-us/off2000/html/ofhowAddCommandToMenu.asp
After you've created your custom menu, select the Tools -> Startup... menu
to open the Startup dialog window. Select the "Menu Bar:" combo box and
change (default) to the name of your custom CommandBar. Uncheck the "Allow
Full Menus" and "Allow Special Keys" check boxes. Select the "Display
Form/Page" combo box and select your startup form. Uncheck the "Display
Database Window" check box. Any other changes in this dialog window can be
made at your discretion. Select the "OK" button to save the changes. Close
the database and then reopen it and you'll see the built-in menu momentarily
(this depends upon how fast your computer is) and then your custom CommandBar
will be displayed.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
