Ok, I looked at you examples and I created a table called tblHelpText with the same structure. I entered one record with the HelpID of 1. The I entered 1 in the Tag property in the field unitnumber. I created a button called cmdHelp and copied your code into it. When I click on it it returns the name of the field which I understand but how do I return the actual help text?
With warm regards,
Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training
From: Crystal <strive4peace2008@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, June 30, 2011 5:16 PM
Subject: Re: [MS_AccessPros] Developing a help system
Hi Art,
download this for some ideas:
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/Forms_With_Help_Examples_Crystal__MDB_DOC_HTM_TXT.zip
since you want to do help for each control, maybe use the TAG property to store the HelpID you want displayed. You can make a command button and use the PreviousControl property to know where the user just was
here is a code start for you, assuming your command button has the Name --> cmdHelp
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Private Sub cmdHelp_Click()
MsgBox Screen.PreviousControl.Name,,"Tag: " & Screen.PreviousControl.Tag
End Sub
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Thu, 6/30/11, Art wrote:
> I have a custom database which I
> would like to add a custom help system for each field. Does
> any one have an example of one or ideas how to approach it.
>
> Thanks,
>
> Art Lorenzini
> Sioux Falls
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar