Open a form from a menu bar

[magicdds]

I created a blank menu bar called Custom1.

I want to have the word HELP displayed on the menu bar. When the user clicks
on the word HELP, I would like the form named HELP_INFORMATION to open.

How do I add the word HELP to the menu bar and have it open the correct form.

Thanks
Mark

 

[Keith Wilby]

I created a blank menu bar called Custom1.

I want to have the word HELP displayed on the menu bar. When the user
clicks
on the word HELP, I would like the form named HELP_INFORMATION to open.

How do I add the word HELP to the menu bar and have it open the correct
form.

Thanks
Mark

Use the "customize" menu option to rename your button. To have it open your
form, right-click the button in "customize" mode, choose "properties" and
put the following into the "on action" box:

=libAbout("HELP_INFORMATION")

.... and in a code module put:

Public Function libAbout(gcFrmAbout)

DoCmd.OpenForm gcFrmAbout

End Function

So when the button is selected it will call the function and open the form.

Keith.
www.keithwilby.com

 

[Keith Wilby]

For access 2003 and maybe other versions?

Right click on the tool bar and select customize

Go to the commands tab

select all forms in the left box

then find your form and drag it to your menu bar from the right box

Leaving the dialog box open right click on the icon you dragged and rename
it Help then select Text Only(Always)

Hopefully that should do the trick

Well I never! It seems my method dates from A97. Thanks for that, it's one
fewer functions I need now.

Keith.

 

[magicdds]

This worked perfectly. Thanks.

One more question. How do I now get rid of the box on the right side of the
menubar that says "Type a question for help"?

Thanks again,
Mark

 

[Albert D. Kallal]

This worked perfectly. Thanks.

One more question. How do I now get rid of the box on the right side of
the
menubar that says "Type a question for help"?

right click the menu bar and select customize.

Then, right click on the "ask a question box"....you can check/uncheck the
box to show, or hide the box.....