open the internet explorer from access (1 Viewer)

I want to open the internet explorer from access

but with url

for example

dim strUrl as string
strUrl = "http://www.google.com"

'here I want to open the explorer with the strUrl

thanks!

Open your form in design mode and insert Hyperlink :
ensure that in the label properties the correct hyperlink address is given, i.e.:

http://www.access-programmers.co.uk/forums/

The on click event on that label should fire off the requested Url.

thanks!

first I need it by code no by link

second i found this code
my problem now is that the internet explorer open minimize I want to open it maximize and to focuse the i.e.

On my PC using Windows XP sp2 and MS Access 2003 sp2, using the above example:

Call Shell("explorer.exe " & strUrl, vbMaximizedFocus)

My Internet Explorer does not open Maximized. Nor Minimized I mean in the taskbar, but in a sized window even though I previously maximized IE and closed it.

Actually I now tried all the WindowStyle combinations, including vbMinimizedFocus and they all do the same, open a sized window!


On a side note, this has been nagging me for years. Why does a hyperlink set via VBA to an unbound field with the Hyperlink property set to yes, not work?!? Tried plain web link and adding #'s, nothing works. Not clickable!!!