[AccessD] Executing Internet Links From Within Access

MartyConnelly martyconnelly at shaw.ca
Fri Jun 17 10:08:26 CDT 2005


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






More information about the AccessD mailing list