[AccessD] Executing Internet Links From Within Access

Thanks for that, will test it out after the weekend.




Message date : Jun 17 2005, 04:10 PM
>From : "MartyConnelly" 
To : "Access Developers discussion and problem solving" 
Copy to : 
Subject : Re: [AccessD] Executing Internet Links From Within Access
Code below is easiest way otherwise you have to enter address in a 
hyperlink field of table
which requires a specific format URL Name#URL address#subaddress
"My MS site"#"http://www.microsoft.com"#
Then you can assign this field to a clickable Label or TextBox

The following function prompts a user for a hyperlink address and then 
follows the hyperlink:
You could assign this function to a command button

Function GetUserAddress() As Boolean
Dim strInput As String

On Error GoTo Error_GetUserAddress
strInput = InputBox("Enter a valid address")
Application.FollowHyperlink strInput, , True
GetUserAddress = True

Exit_GetUserAddress:
Exit Function

Error_GetUserAddress:
MsgBox Err & ": " & Err.Description
GetUserAddress = False
Resume Exit_GetUserAddress
End Function

paul.hartland at fsmail.net wrote:

>To all,
>
>A friend of mine has a website which he has to go to everyday to exceute several other pages, would it be possible to insert these into an Access table and run some code which would trigger them ?
>
>Thanks in advance for any help/sample code on this issue
>
>Paul Hartland
>
> 
>

-- 
Marty Connelly
Victoria, B.C.
Canada



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm