On my form, the user clicks submit at which point in time the form closes. I would like then to have a specefic html page automatically open up in IE...so, it needs to start IE, and then to go a web site.

shell "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://www.google.com"

that code does what I wish it to do; however, the session of explorer isn't maximized and it isn't set to active (for lack of a better term, I mean it opens, but you have to click the IE icon on the taskbar on bottom of screen to see it...I wish it to pop up and be active meaning showing on the screen)

any ideas? thanks!

I found a solution...

Application.FollowHyperlink "Http://www.google.com"


thanks!

If you use the Microsoft Web Explorer control - find it in the ActiveX controls menu - then you can put a web page on a form in Access. ;)

If you still want the external opening of the web page you almost had what you wanted using Shell. You just needed the vbMaximizedFocus at the end of the command. Like this...

Shell "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://www.google.com", vbMaximizedFocus