Results 1 to 4 of 4
  1. #1
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615

    Msgbox function with Help option

    Using Access 2010 on Windows 7:

    I want to be able to use the Msgbox procedure with the Help button to access context-sensitive help.

    However, no matter what I try, the msgbox call does not display the "Help" button. I have made sure the help file I specify exists, and that the context ID exists, but nothing works - no Help button.



    Does anyone know why this is happening?

    On a related topic - there seems to be some debate as to whether Msgbox can use .chm files, or whether it has to have an .hlp file. My department has given me Robohelp 11, which does not generate .hlp files. It seems to me it would make sense that it could use .chm, a much newer technology. Can anyone set the record straight on that issue? (Of course, it's a moot point if I can't see the Help button in the first place!)

    Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    John, I don't have experience with the help/context options. I did some searching and found this. I haven't tried it and it may not be relevant for your situation. However, it may be worth reading. Seems he has a custom class and provides a download.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    The Constant for the Help button is

    vbMsgBoxHelpButton

    as in

    MsgBox ( prompt [, vbMsgBoxHelpButton ] [, title ] [, helpfile ] [, context ] )

    And you must supply the helpfile and context parameters in order to use the Help button.

    Have a look here for a more complete explanation:

    https://support.office.com/en-us/art...rs=en-US&ad=US

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Thanks, Linq - it worked perfectly. I was missing the vbMsgBoxHelpButton part. And it does work with compiled .chm files.

    John

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 12-16-2013, 04:24 PM
  2. Combo Box Wizard does not have option form option
    By CementCarver in forum Forms
    Replies: 5
    Last Post: 02-28-2013, 08:54 PM
  3. MsgBox with a password option?!!
    By avworx in forum Programming
    Replies: 8
    Last Post: 05-23-2011, 06:52 PM
  4. no option to import xls file or option all files
    By captgnvr in forum Import/Export Data
    Replies: 3
    Last Post: 09-22-2009, 10:19 AM
  5. pass a variable to the MsgBox function
    By 3dmgirl in forum Programming
    Replies: 2
    Last Post: 04-19-2007, 07:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums