Access to HTML

[Rizza]

I am looking for an example of how to pass a value from access to a web page
input box. I would like to use VBA rather than third party software if
possible.

 

[Rick Brandt]

I am looking for an example of how to pass a value from access to a
web page input box. I would like to use VBA rather than third party
software if possible.

You can submit HTTP requests using the MSXML library.

Dim MyPostData As String
Dim MyURL As String
Dim oHttpPost As Object

MyPostData = "SomePageVariable=SomeDataValue"
MyURL = "http//www.SomeDomain.Com/SomePage"
Set oHttpPost = CreateObject("Microsoft.XMLHTTP")
oHttpPost.Open "POST", MyURL, False
oHttpPost.setRequestHeader "Content-Type",
"application/x-www-form-urlencoded"
oHttpPost.Send (MyPostData)