Setting Up Form Help / Instructions

N

Nick hfrupn

I am looking for a way of setting up help / instructions for the use of forms
in my database. I have used help tips for buttons and fields but I would like
to set up detailed instructions for the use of each form.
I have thought about setting up a help table, query and form, so that when
you press a button on the active form, the help form opens and the source
data comes from the help query using the active form’s name as the criteria.
I don’t know if this is possible or the best way to go about it.

I would appreciate any suggestions.

Nick
 
O

Ofer

Mybe there is a better way now, but we set up a help for the form with older
version of access, so if you wont get any better response then
1. Create a table "HelpTable" with two fields: FormName String, MessageText
Memo
2. Create a macro called AutoKeys:
In the macro propeties write the following
In the MacroName {F1}
In the action select RunCode
In the function name on the buttom write a function name =OpenHelpMessage()
3. Create a function in a module called OpenHelpMessage()

Function OpenHelpMessage()
Dim Message as string
Message=nz(dlookup("MessageText ","HelpTable","FormName ='" &
Application.Screen.ActiveForm.Name & "'"),"0")
If Message <> "0" then
msgbox Message ' Or open a form instead
End if
End Function
 
Top