URL from Access Database

Does anyone know how to access a webpage by just clicking button on a form in Access. I am creating a file for upload to the site and I want to be able to go directly to the site once the file is created.

Thanks

Insert...Hyperlink

How do I do this in the command button click event?

VB Code:

Dim lReturn As Long
     lReturn = ShellExecute(hwnd, "open", "http://w3.iapps.tdbank.ca/nso/order.nsf", vbNull, vbNull, 1)

Try that.

Use your own URL though. :)

I tried your code but I get an error saying that the method isn't found.

Any clues?

I was thinking of using a webbrowser object, I have no idea if that will even work in VBA.

My apologies. You need to declare this first.

VB Code:

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _
ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Then your method will be found.