Custom Help Files

[rcollins]

I want to make a help file where all of the help info is in a table. The fields would be ID, Help and Description. I want it to work so when I click on button called Command 22, that it pulls up the help and description for ID = 1 and so on for however many help items I put in the table
I am using windows XP and Office 2003

[Scott Price]

I want to make a help file where all of the help info is in a table. The fields would be ID, Help and Description. I want it to work so when I click on button called Command 22, that it pulls up the help and description for ID = 1 and so on for however many help items I put in the table
I am using windows XP and Office 2003

Do you want this help file to be context sensitive? I.E. when working on a specific form have a Help button that will load the help text for that specific form?

If so, you'll need to expand the structure of your help system, to include a Database objects table that you can then link to the help table using a foreign key reference. You'll need to place a hidden control that contains the FormID # on each form also.

Then you'll need to dynamically create an sql query on the click event of the command button.

Regards,
Scott

[rcollins]

Do you want this help file to be context sensitive? I.E. when working on a specific form have a Help button that will load the help text for that specific form?

If so, you'll need to expand the structure of your help system, to include a Database objects table that you can then link to the help table using a foreign key reference. You'll need to place a hidden control that contains the FormID # on each form also.

Then you'll need to dynamically create an sql query on the click event of the command button.

Regards,
Scott

All I need is for when they click a button, it pulls up the one record. The help for each button is specific, directions for that part of the form, so that is why I wanted to have it pull up by ID so it only has one choice. Should be simple...

[Scott Price]

All I need is for when they click a button, it pulls up the one record. The help for each button is specific, directions for that part of the form, so that is why I wanted to have it pull up by ID so it only has one choice. Should be simple...

Are you having specific problems with how to do this, or are you looking for an overview of the process?

So far, I'm not sure what you are really looking for as an answer to this thread!

Regards,
Scott

[rcollins]

Are you having specific problems with how to do this, or are you looking for an overview of the process?

So far, I'm not sure what you are really looking for as an answer to this thread!

Regards,
Scott

In visual studio editor, I have

Private Sub Command22_Click()
On Error GoTo Err_Command22_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "frmHelp"
 
 
    DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.ApplyFilter , "ID = '1'"
 
Exit_Command22_Click:
    Exit Sub
 
Err_Command22_Click:
    MsgBox Err.Description
    Resume Exit_Command22_Click
 
End Sub
 

When I click on the button it says "Aplly Filter action was canceled"
When I click OK all of the records are showing.

[puppydogbuddy]

FYI and ideas, see this link for a third party Help System constructed using an Access form and table as you described:

http://www.acc-technology.com/hpwiz.htm

[puppydogbuddy]

In visual studio editor, I have

Private Sub Command22_Click()
On Error GoTo Err_Command22_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "frmHelp"
 
 
    DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.ApplyFilter , "ID = '1'"
 
Exit_Command22_Click:
    Exit Sub
 
Err_Command22_Click:
    MsgBox Err.Description
    Resume Exit_Command22_Click
 
End Sub
 

When I click on the button it says "Aplly Filter action was canceled"
When I click OK all of the records are showing.

http://www.acc-technology.com/hpwiz.htm[/quote]


I would do it this way (assuming ID is a numeric field):
I am also assuming that you have a textbox control bound to your ID field named txtID....change to actual name of textbox
stLinkCriteria = "[ID] = " & Me!frmHelp!txtID
DoCmd.OpenForm stDocName , , , stLinkCriteria

If ID is text data type, do it like this:

stLinkCriteria = "[ID] = '" & Me!frmHelp!txtID & "'"
DoCmd.OpenForm stDocName , , , stLinkCriteria