Open website

[mcginty]

Hi All,

I have a text box where a web address is typed in. How can I use a button to open that site in a browser?

Rgds,
Ted

 

[Maquis]

You can put this code in the on_click event of the button.

Dim address As String
address = Me!<textboxnamehere>
Application.FollowHyperlink address, , True
Maq
<insert witty signature here>

 

[mcginty]

Thanks Maq,

This is exactly what I want to do but I'm getting an error message : &quot;Run-time error 432. File name or class name not found during Automation operation&quot;

Any ideas?

Rgds,
Ed

 

[Maquis]

Hmmm, I don't know. What version of Access are you using?
This code works fine for me in Access 97, but it's possible (ok, probable) that they have changed the language for Access 2000 and up.

Look up the Application keyword in Access help and see what they list. If they got rid of it, perhaps it will tell you what they replaced it with. Maq
<insert witty signature here>

 

[mcginty]

Thanks Maq,

I had the website as

http://www.xyz.com,

but it works with http:// before the address.

Thanks again,
Ed