Module: HelpHTML in Category Windows : Help Files from Total Visual SourceBook

' Example of modHelpHTML
'
' To use this example:
' 1. Create a new form
' 2. Create the following command buttons:
'       'cmdOpen'
'       'cmdClose'
' 3. Create a combo box named 'cboOpenTo'
' 4. Create the following text boxes:
'       'txtFile'
'       'txtContextID'
'       'txtTopic'
' 4. Paste the entire contents of this module into the new form's module.

Private Sub cmdClose_Click()
  Help_HTML_CloseAll
End Sub

Private Sub cmdOpen_Click()
  ' Constant to control whether the help file is maximized when opened.
  Const cfMax As Boolean = False

  Select Case Me.cboOpenTo
    Case "ContextID"
      Help_HTML Me.txtFile, Me.txtContextID, cfMax
    Case "Contents"
      Help_HTML_Contents Me.txtFile, cfMax
    Case "Index"
      Help_HTML_Index Me.txtFile, cfMax
    Case "Search"
      Help_HTML_Search Me.txtFile, cfMax
    Case "Topic"
      Help_HTML_Topic Me.txtFile, Me.txtTopic, cfMax
  End Select
End Sub

Private Sub Form_Load()
  ' Constants to use as defaults
  Const cstrHelpFile As String = "TVSB.chm"
  Const cstrTopic As String = "Example_Code"
  Const clngID As Long = 32

  ' Provide full path to help file. Uses Access command for the current database's path.
  Me.txtFile = CurrentProject.Path & "\" & cstrHelpFile

  Me.txtContextID.Format = "#"
  Me.txtContextID = clngID
  Me.txtTopic = cstrTopic

  ' Captions on buttons
  Me.cmdClose.Caption = "Close All"
  Me.cmdOpen.Caption = "Open Help"

  With cboOpenTo
    .RowSourceType = "Value List"
    .RowSource = "ContextID;Contents;Index;Search;Topic"
    .LimitToList = True
    .Value = "ContextID"
  End With
End Sub

The source code in Total Visual Sourcebook includes modules and classes for Microsoft Access, Visual Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily add this professionally written, tested, and documented royalty-free code into your applications to simplify your application development efforts.

Total Visual SourceBook is written for the needs of a developer using a source code library covering the many challenges you face. Countless developers over the years have told us they learned some or much of their development skills and tricks from our code. You can too!

Additional Resources

• List of All Modules in Total Visual SourceBook
• List of All Code Categories in Total Visual SourceBook
• Sample Module Code from Total Visual SourceBook (Example of Date, Time and Age Calculations)