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