Hyperlink

[nat22]

Hello ,
I have ListBox and I have put in ControlSource:
SELECT HorizontalniDrzaciKabela.Referenca, HorizontalniDrzaciKabela.Opis, HorizontalniDrzaciKabela.Visina, HorizontalniDrzaciKabela.Napomena FROM HorizontalniDrzaciKabela WHERE (((HorizontalniDrzaciKabela.PickFlag)=False));

Can I make column HorizontalniDrzaciKabela.Napomena as hyperlinks for each record when I open ListBox?

In design view I put Napomena as hyperlink (I have added hyperlinks) but it will not work,

thank you in advance

 

[ansentry]

Try this:

Dim strHyperlink As String

strHyperlink = Me.NameOfYourListBox.Column(3)

Application.FollowHyperlink strHyperlink, , True

In your case I think column(3) is correct.

Referenca = 0
Opis=1
Visina = 2
Napomena = 3

Put the code behind the list box in the on click event. After you have pasted the code Put the cursor on FollowHyperlink and push F1 and you will see a function in there that you can change to suit you list box.

In your table make sure that Napomena is set to text "Data Type" and NOT hyperlink "Data Type"

 

[nat22]

Hello,
thaks for your advice, the name of my TextBox is Polica,so I have situation:

Private Sub Polica_DblClick(Cancel As Integer)
Dim strHyperlink As String

strHyperlink = Me.Polica.Column(3)

Application.FollowHyperlink strHyperlink, , True
End Sub

where I can define Hyperlink addresses for each record?

thank you in advance

 

[ansentry]

In your first post you state:

I have ListBox and I have put in ControlSource:

Now you say:

the name of my TextBox is Polica

now I am confused!

Attached is a sample database, see if it helps you.

where I can define Hyperlink addresses for each record

Have a look at the table.

 

[nat22]

Great John,

this is solution for my problems,thank you very much,

best regards,

Damir

 

[ansentry]

I am glad that it was a help to you.