Opening a website through Access

[Imran Ghani]

Hi! I want to access a website through my Access 2007 form with VBA code.
Kindly help me how can this be done. Thanks

 

[NevilleT]

Hi Imran
Suggest you create a hyperlink field in your table and enter the web address
there. Your form can then display the hyperlink, or alternatly have a button
that calls the hyperlink based on a name for the site.

 

[Imran Ghani]

Thanks a lot for your prompt reply. Can you please suggest the VBA code for
accessing the website through a button on the form.

 

[Jack Leach]

Application.FollowHyperlink "http://www......""

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Jack Leach]

Suggest you create a hyperlink field in your table and enter the web address

there. Your form can then display the hyperlink, or alternatly have a button
that calls the hyperlink based on a name for the site.

Just as a side note...

Using a hyperlink field tends to store more info in the tables than is
strictly necessary. Many developers will instead store this as a string and
use the IsHyperlink property of a control on the form, and call it through
code via the Application.FollowHyperlink method, or the Shell function or
ShellExecute API.

Often a string is easier than dealing with the hyperlink syntax (which is
quite a bit different than that of a string) as well, and the only place you
ever really need that is on a form anyway.

Something to consider maybe.

Happy coding

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)