Custom Menu... Almost

SerranoG · January 29th, 2004, 09:29 AM

I was able to use macros to create my custom menus in Access XP. I was also able to create macros to hide all toolbars while my form is open and display just my menus, except...

How do you hide that "Type a question for help" combobox on the upper right on the menu bar when the form opens and reset it when the form closes?

When I use RoboHelp to create my customized help files and attach it to my database, will that combobox interact with my help files or always default to Access XP's? If XP's, how can I get it to interact with mine?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

BethMoffitt · January 29th, 2004, 11:03 AM

See if this is what you were looking for:

Code:

Sub ToggleQuestionDropdown()
    With Application.CommandBars
        If .DisableAskAQuestionDropdown = True Then
            .DisableAskAQuestionDropdown = False
        Else
            .DisableAskAQuestionDropdown = True
        End If
    End With
End Sub

The Help files interact with your application by using the 'Help Context ID' in the form (or control's) property sheet under the 'Other' tab.

HTH,

Beth M

SerranoG · January 29th, 2004, 05:40 PM

Thanks, that did the trick. Do you know of any place where a list of these obscure but useful control properties exist? I searched the help files, but never in a million years would I have known it was called that, so therefore my search yielded zippo.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

BethMoffitt · January 29th, 2004, 05:59 PM

Unfortunately Greg, no I don't. I happened to stumble across that one about a month ago in Help while I was looking for something else. But isn't that the way we usually find things? :/

Beth

SerranoG · January 30th, 2004, 08:42 AM

Quote:

quote:Originally posted by BethMoffitt
But isn't that the way we usually find things? :/

You're not kidding. Oh, I tested my own question. I have a program where I created help and associted it with my Access database. Whereas the F1 key did, indeed, pull data from my help files, that combobox still drew its help advice from Access help, not mine.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

BethMoffitt · January 30th, 2004, 09:50 AM

Greg,

I have never used the Context Help ID feature, nor RoboHelp, but my understanding is that in the Help file you have to assign the ID to a topic, then assign that same ID to the appropriate control in the properties box.

Wish I had further advice, but if you search M$ Knowledge Base, maybe it will provide more info.

Beth M