Hyperlinking

[P-chu via AccessMonster.com]

I'm sure this is simpler than what I've been trying. I have a combo box that
displays hyperlinks from a table. Works great, but you must click the
hyperlink selection twice from the combo box to make it work. The hyperlinks
just go to generic documents located on the server. Very basic. Any help.
I tried this to no avail:

Private Sub Combobox1_AfterUpdate()
Me.[Combobox1].Requery
End Sub

Thanks.

 

[dan.cawthorne]

I'm sure this is simpler than what I've been trying.  I have a combo box that
displays hyperlinks from a table.  Works great, but you must click the
hyperlink selection twice from the combo box to make it work.  The hyperlinks
just go to generic documents located on the server.  Very basic.  Anyhelp.
I tried this to no avail:

Private Sub Combobox1_AfterUpdate()
Me.[Combobox1].Requery
End Sub

Thanks.

P-Chu

I've done somthing very similar instead of making the combo box a
hyper link, leave it as a normal text type format.

and then you could put the following code on the Double Click Event of
the combo

Dim strFolderPath As String
strFolderPath = Me.ComboBox1
Application.FollowHyperlink strFolderPath

Or you could create button next to the combox which then opens the
folder?

Hope this helps

Dan

 

[P-chu via AccessMonster.com]

Thanks bunches Dan.

I'm sure this is simpler than what I've been trying.  I have a combo box that
displays hyperlinks from a table.  Works great, but you must click the

[quoted text clipped - 10 lines]
P-Chu

I've done somthing very similar instead of making the combo box a
hyper link, leave it as a normal text type format.

and then you could put the following code on the Double Click Event of
the combo

Dim strFolderPath As String
strFolderPath = Me.ComboBox1
Application.FollowHyperlink strFolderPath

Or you could create button next to the combox which then opens the
folder?

Hope this helps

Dan