Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 29th, 2004, 09:29 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default Custom Menu... Almost

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
__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division
 
Old January 29th, 2004, 11:03 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old January 29th, 2004, 05:40 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

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
 
Old January 29th, 2004, 05:59 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old January 30th, 2004, 08:42 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

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
 
Old January 30th, 2004, 09:50 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Menu Paula222 ASP.NET 1.x and 2.0 Application Design 0 November 8th, 2006 09:21 AM
Custom Menu Paula222 .NET Framework 2.0 0 November 8th, 2006 09:08 AM
Creating Custom Menu Component in JSF.....Pls help Finny J2EE 0 September 10th, 2004 06:24 AM
Custom Menu slgknjn Excel VBA 4 June 3rd, 2004 01:20 AM
Custom Menu Manipulation SerranoG Access 0 June 19th, 2003 03:55 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.