Open hyperlink IN form

[MartijnWils]

Hey everybody,

I made a program that opens an hyperlink (in VBA). only problem is that it opens in IE and not in the form or Access.

I want it to open in Access or in the form.

here is an example of the code i got at the moment:

Private Sub Knop17_Click()
 
Dim sWebSite As String
sWebSite = "[URL]http://interlight.e-nitiative.be/BIA_common/BIA_searchL8.ASP?searchstr[/URL]=" & artikel_volgnr
Application.FollowHyperlink swebstite, , True
 
End Sub

i know you can put a property that it opens in newwindow, i did that to ! (its the true in the line from application.followhyperlink) i also tried to put it on false but then it doesnt do anything

 

[DCrake]

Have you got an Web browser control on your form yet?

David

 

[MartijnWils]

No, whats that and how do I use it ?

is there also another way ? I need to make a for a company so needs to be as professional as possible

 

[DCrake]

Don't know what version of Access you are using but if you desing a form and select Insert > ActiveX Control then scroll down to Web Browse Control and click apply. You effectively have an inbuit web browser on your form and this will act as the repository of the IE control. Have not used it in years but I know it works.

David

 

[MartijnWils]

Ok i found it ! TY !

but how do i put this in another form and then when i click on the button it goes to that form and open the browser there ?

I got it now, but its in the same form