Custom Toolbars

J

Jenn

I need to make a custom toolbar that shows forms I have created. I need to
make a pull down that is called "entry forms" and when the user clicks this a
list of 3 forms is shown and he can select one of those form names and the
form will pop up. I saw the other post on custom toolbars but when I tried
to click on the link it denied me access to view the article. Does anyone
know how to create this pull down to view my forms?
TIA.
 
6

'69 Camaro

Hi, Jenn.
I saw the other post on custom toolbars but when I tried
to click on the link it denied me access to view the article.
Click to expand...

Was it one of the following links?

http://msdn.microsoft.com/library/d...chowCreateCustomMenuBarForCurrentDatabase.asp

http://msdn.microsoft.com/library/d.../en-us/off2000/html/ofdccCreateCustomMenu.asp

http://msdn.microsoft.com/library/d...y/en-us/off2000/html/ofdccAddOrDeleteMenu.asp

http://msdn.microsoft.com/library/d.../en-us/off2000/html/ofhowAddCommandToMenu.asp

http://msdn.microsoft.com/library/d...tomCommandThatPerformsVisualBasicFunction.asp
Does anyone
know how to create this pull down to view my forms?
Click to expand...

You'll read the instructions on the Web pages for the links above.
Basically, once you create your user-defined public functions in a VBA module
to open each individual form, use the name of this function in each custom
menu item's On Action Property in the Properties dialog window. For example:

=OpenFrmDataEntry()

.. . . which calls the public OpenFrmDataEntry( ) function that's already
been defined to open the frmDataEntry form.

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.
 
Top