How to automatically fill in a web page form field?

[MLH]

I can launch a session of IE from Access 97
database. For instance, I want to page my
friend, I go to http://www.arch.com/message/
then type his 800XXXXXXX number in the
field and click Continue...

I would be happy if I could program
MS Access with the properly formatted
URL string to automatically type the 10-digit
phone number in there for me - so I don't
have to type it in manually each time.

First of all, I'll have to know how to properly
format a URL string to even do that.

Anybody wanna take a stab?

[Salad]

MLH wrote:

I can launch a session of IE from Access 97
database. For instance, I want to page my
friend, I go to http://www.arch.com/message/
then type his 800XXXXXXX number in the
field and click Continue...

I would be happy if I could program
MS Access with the properly formatted
URL string to automatically type the 10-digit
phone number in there for me - so I don't
have to type it in manually each time.

First of all, I'll have to know how to properly
format a URL string to even do that.

Anybody wanna take a stab?

Maybe check the classname and caption (see http://www.mvps.org and the
API calls) and see it the proper app is open and at the right site.
There's probably an API call to set focus to the app and then use Sendkeys.

[MLH]

Maybe check the classname and caption (see http://www.mvps.org and the
API calls) and see it the proper app is open and at the right site.
There's probably an API call to set focus to the app and then use Sendkeys.

Thanks, Salad. I'll check mvps.org for classname and caption, just to
see what that turns up. I already use something like the following to
access another web page...

Dim msXML As Object, strPageContent As String, MyURL As String

Set msXML = CreateObject("Microsoft.XMLHTTP")
MyURL = "http://www.autocheck.com/consumers/gatewayAction.do?siteID=9
56&affid=CDT&vin=" & Me!SerialNum
msXML.Open "GET", MyURL, False
msXML.send
strPageContent = msXML.responseText

So, I've had success with it. But I've been able to provide the full
text of the URL (MyURL) to the msXML.Open statement. The website
I'm trying to hit now poses a bit of a different challenge. Let me
know if you come across anything else that looks promising.

[rkc]

MLH wrote:

Thanks, Salad. I'll check mvps.org for classname and caption, just to
see what that turns up. I already use something like the following to
access another web page...

Dim msXML As Object, strPageContent As String, MyURL As String

Set msXML = CreateObject("Microsoft.XMLHTTP")
MyURL = "http://www.autocheck.com/consumers/gatewayAction.do?siteID=9
56&affid=CDT&vin=" & Me!SerialNum
msXML.Open "GET", MyURL, False
msXML.send
strPageContent = msXML.responseText

So, I've had success with it. But I've been able to provide the full
text of the URL (MyURL) to the msXML.Open statement. The website
I'm trying to hit now poses a bit of a different challenge. Let me
know if you come across anything else that looks promising.

If you look at the html source of the page at
http://www.arch.com/message/ you will see that the form
action is to send a request for /cgi-bin/wwwpreproc.cgi.
The method is Post so the form's data is not sent as a
query string appended to the url. It's sent in the body
of a message. If you do a search on how to Post a message
using XMLHttp you will eventually sort things out on your
own.

[MLH]

Thanks, rkc, will give 'er a try.

If you look at the html source of the page at
http://www.arch.com/message/ you will see that the form
action is to send a request for /cgi-bin/wwwpreproc.cgi.
The method is Post so the form's data is not sent as a
query string appended to the url. It's sent in the body
of a message. If you do a search on how to Post a message
using XMLHttp you will eventually sort things out on your
own.