Prev: My product key
Next: Converting data to appear in uppercase letters in a table
From: JSSherm on 24 Jun 2008 23:07
Is it possible to add a hyper-link to combo box items. I'm making a list of
dog breeds and would like the viewer to click each specific breed that would
link to a detailed PDF of that breed.
From: Ken Snell (MVP) on 24 Jun 2008 23:17
Not in the value that is being displayed in the combo box, but you can do it
indirectly.

Add a field to the query that is the Row Source of the combo box -- use this
field to hold the path to the PDF document for the breed in that record.
Then, use VBA code to open that PDF document when the user, for example,
double-clicks the combo box. Assuming that the PDF path field is the second
column in the combo box's Row Source query, the code would look something
like this:

Private Sub ComboBoxName_DoubleClick(Cancel As Integer)
If Len(Me.ComboBoxName.Column(1) & "") > 0 Then _
Application.FollowHyperlink Me.ComboBoxName.Column(1)
End If

--

Ken Snell
<MS ACCESS MVP>


"JSSherm" <JSSherm(a)discussions.microsoft.com> wrote in message
news:2A2BE709-C7BF-435E-8671-AEB5E13C605A(a)microsoft.com...
> Is it possible to add a hyper-link to combo box items. I'm making a list
> of
> dog breeds and would like the viewer to click each specific breed that
> would
> link to a detailed PDF of that breed.


 | 
Pages: 1
Prev: My product key
Next: Converting data to appear in uppercase letters in a table