Hyperlink Controls on Forms

[Guest]

It doesn't seem possible to insert more that one hyperlink in a single
control. I was hoping to have a control on a form in which I could link
several word documents over time(performance reports) regarding the same
employee. Is this possible and if so how?

 

[Guest]

It ould be a good idea to create a new table eg tblPerformance, and then
create a one to many relationship between tblEmployee (1) and tblPerformance
(M). Then create a form for the tblPerformance, which includes the field
txtPerformaceLink(which is a hyperlink to your performance report). Then you
just make this a continuous form (not a single form). Obviously the form
would have to be fairly small in height to look good. You could also make it
a single form but have navigation buttons to navigate through the performance
reports records.

It may pay to adda command button to help the user insert the hyperlink to
the document/website or whatever. I would create a command button
(cmd_insert_hyperlink) with the following code to open the hyperlink dialog
box where you can navigate to the document you require.

*** CODE STARTS HERE***

Private Sub cmd_insert_hyperlink_Click()

' Set focus to the performance link field
Me.txtPerformaceLink.SetFocus

' Bring up the "hyperlink to" box.
' Is the same as pressing Ctrl + K
SendKeys "^k", False

End Sub

*** CODE ENDS HERE ***

Hope this helps.

Dylan