Solved Open full URL within access

[paulthepilot]

I have the following code that will not work

Dim StrUrl As String
StrUrl = http://www.racingpost.co.uk/horses/trainer_form.sd?trainer_id=17740
Call Shell("explorer.exe " & StrUrl, vbMaximisedFocus)

The following does work
Dim StrUrl As String
StrUrl = http://www.racingpost.co.uk/
Call Shell("explorer.exe " & StrUrl, vbMaximisedFocus)

Why, when I add the rest of the url does it not work
The url is valid and works as a hyperlink
I don't want to use a hyperlink because I will eventually change the id to a query generated number

Help !

 

[wazz]

your urls are not in quotes.

if you want internet explorer try calling iexplore with the path:

Dim dblRetVal As Double
dim strUrl as string
    
strUrl = "..."
dblRetVal = Shell("C:\Program Files\Internet Explorer\iexplore.exe " & strUrl, vbMaximizedFocus)
Debug.Print dblRetVal

 

[paulthepilot]

Thanks
I knew I was doing something stupid, I just couldn't grasp what it was