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