Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    vbMsgBoxHelpButton (2000 sr1)

    I have this piece of code:

    If Check_Mandatory Then
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
    Unlock_Scrolling
    WriteLog Now(), CurUser, Me![project Number], "Record Saved: " & Me![project title]
    Else
    RetVal = MsgBox("All fields marked with an Asterix (*) are mandatory." & vbCrLf & vbCrLf & _
    "Would you like to edit this record?" & vbCrLf & _
    "(Selecting 'No' will cancel this record!)", vbMsgBoxHelpButton + vbYesNo + vbExclamation, "Mandatory Data Missing")
    Select Case RetVal
    Case vbYes
    Me!Page4.SetFocus
    Me![project title].SetFocus
    Exit Sub
    Case vbNo
    btnUndo_Click
    Exit Sub
    Case vbMsgBoxHelpButton
    MsgBox "Mandatory fields are: Project Title," & vbCrLf & _
    " Date of Research," & vbCrLf & _
    " CI Contact," & vbCrLf & _
    " Business Unit," & vbCrLf & _
    " Cost," & vbCrLf & _
    " CI Manager," & vbCrLf & _
    " Client Senior Mgr," & vbCrLf & _
    " Agency," & vbCrLf & _
    " Objectives.", vbOKOnly + vbInformation, "Mandatory Fields Listing"
    Me!Page4.SetFocus
    Me![project title].SetFocus
    Exit Sub
    End Select
    End If

    Why is it that if the users select the Help button, nothing happens? Even in break mode, the dialogue box just sits there, and does nothing until another option is selected. Surely the help button should return a value of 16384 (Const vbmsgboxhelpbutton)?

    I thought that it may be because I do not have a help file associated with the db, but surely this would return an error?

    Any suggestions, other than building my own dialogue box form?

    Thanks

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: vbMsgBoxHelpButton (2000 sr1)

    The message box help button doesn't cause the message box to close. It merely displays the help message as specified by the Help File and Context included in the msgbox command line. Previously, if these were specified, the user had to use F1 to get help.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •