list property

[vlad123]

I have a list box with all web sites resulted from a google search. I want that when I double click on one link from the list to be able to open that page. I can do this in VB using list property, but in Access?
I send u a piece of my code for DblClick event in VB:
MyBrowser.navigate lstLinks.List(lstLinks.ListIndex)

 

[KenReay]

Hi

does this point you in relevant direction?

Private Sub Form_Load()
Dim ctl As CommandButton
Set ctl = Me!Command0
With ctl
.Visible = False
.HyperlinkAddress = "

http://www.microsoft.com/"

.Hyperlink.Follow
End With
End Sub

(from access help, on hyperlink)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[PHV]

Have a look at the Column properpy of the ListBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vlad123]

I am not sure if u understand corectly. using MSHTML and VBA, I can take all tehe resulted web sites from a google search into a database table. after this, I put all these in a list box or a combo. and I want when I will click on one link from that list to be able to open that page.In VB I can , because I use :
Dim MyBrowser As SHDocVw.InternetExplorer
Set MyBrowser = New SHDocVw.InternetExplorer
MyBrowser.Visible = True
MyBrowser.navigate lstLinks.List(lstLinks.ListIndex)
But, in Access I cant use List property. So, I dont know how to do this.
thanks anyway.
Maybe I need more explications.

 

[Eupher]

vlad123,

To expand on PHV's suggestion - assuming your listbox is NOT multi-select:

MyBrowser.Navigate Me!lstLinks.[COLOR=red]Column(x)[/color]

...where x is the (zero-based!) column in the listbox selection that holds the URL.

Ken S.

 

[vlad123]

Thank you very much! its working with the Column property.