VBA IE interface

Am writing some VB for MS Access 2000 to fill out a web form using information from a database and submit results. I don't control the web site.

Is there a way I can capture the messages passed between IE (v6) and the web site? I'd like to create an app so the user would not have to retype info from the db onto the form.

 

I think I missed something here.

You're writing some VBA to fill out a web form?
Please elaborate.. are you using Accesses Web Pages or are you creating them from scratch with a standard text editor?

 

Basically, yes.

I have an application connected to a database. At the click of a button I want to launch this web page:

http://nysdocslookup.docs.state.ny.us/LOOKUP

with names and other information already entered. There are several other web sites and we have to repeat this process for a large population, so automating the repeditive data entry is a productivity savings as well as less error prone.

 

ok , I think I got you now. you want to tak the info on the database form, click the link and have it automatically populate the form on the web page.
Confirm this so I can figure out how the hell to do that..

btw, the link has changed to this

http://nysdocslookup.docs.state.ny.us/kinqw00

 

Confirmed. I was thinking if I can trap the message IE sends back to the server and manufacture one using names from my db, I could send it out with the click of a button and the user would get the results...we'll that's my current line of thought...

Thanks for the help.

 

here's what I would try to do..

Copy the source of the HTML of that site. make a data access page in access. Then on your form, pass the form field values to the data access page via a query string .

make sure when you save the access page , you give it an ASP extension.

then modify your hyperlink to add the querystring variables to it
(if you need an explaination, let me know)

so when you click on the hyper link it will pass those values to the access page.

Next, on the access page, you'll have to add some script and thus you will need IIS installed run this the way I think to do it.

basically, you find all the form fields on the page and add a value to them. lets say I wanted to pass the first and last name I would do something like this on my form and module.


add the link to the form
make access form fields on form
add button to change the value of the link like so

Private Sub Command4_Click()

Me.blahblah.HyperlinkAddress = "http://localhost/nysdocs.asp?firstname=" & Me.Fname &"&lastname="& me.Lname

End Sub


now change the values on the ASP page for the corresponding values to

<input type="text" name="firstname" value="<%=request.querystring("firstname")%>">

the querystring is case sensitive.


Now, the REAL tricky part is figuring out where to post it to.
I haven't figure out where they are sending the page to yet.

 

got it

http://nysdocslookup.docs.state.ny.us/GCA00P00/WIQ1/WINQ000

that's where they're posting to.. and it appears to work.
If you want, I can call you and walk you through it.

 

So instead of interfacing with the form, I serve it locally and pass the results. Good idea. Thanks!

 

exactly..

 

Could you contact me about this,(http://nysdocslookup.docs.state.ny.us/LOOKUP), i am interested in making a page to do the same thing.


Thnx...

 

Read the whole thread. I explained how you can do this.