Run Application from a button

  • Thread starter Thread starter Pete and Jeannette Smith
  • Start date Start date
P

Pete and Jeannette Smith

I have a button which when clicked takes an email address from a form fires
up Outlook Express and drops the email address into the 'To' field in OE.

I would like to be able to have a similiar thing for website URL's ie when I
click a button it takes the URL from the form filed in Access fires up
Internet Explorer and drops the URL into the IE address line

many thanks
 
I have a button which when clicked takes an email address from a form fires
up Outlook Express and drops the email address into the 'To' field in OE.

I would like to be able to have a similiar thing for website URL's ie when I
click a button it takes the URL from the form filed in Access fires up
Internet Explorer and drops the URL into the IE address line
Click to expand...

Assuming you have the various internet extensions associated with IE (.htm, .html, .asp etc etc) then you can use the
Shell function. In the buttons click event:

Sub Yourbutton_Click()
Shell Me.YourTextboxName",vbNormalFocus
End Sub


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Back
Top