URL from Access Database

[Tesita]

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

[Gaffer]

Insert...Hyperlink

[Tesita]

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

[Ephesians]

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

Try that.

[Ephesians]

Use your own URL though.

[Tesita]

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.

[Ephesians]

My apologies. You need to declare this first.

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.