auto post data to web form

  • Follow


Hi,

I have a client that frequently copies and pastes a couple dozen fields from
an MS Access form to a government web form (I don't know the URL at this
time so I cannot provide that info here). I created the Access app for him.
The web form is NOT something we have access to other than the fact that
they can log in and fill in the information needed. I did not write the web
app, nor did anyone in my client's office. We have no access to modify the
behavior of the web form. In addition, I am not a web developer.

I'd like to put a button on one of the forms in our MS Access app that would
automatically copy and paste certain fields from the MS Access app into the
already open web form just to save them the trouble of doing the copy/paste
process repeatedly. It seems to me that this should be possible via some
sort of Windows API or something like that. If I view the source of a web
page that has something that I can fill in (the box in the middle of the
page www.google.com for example) it seems that I could identify the text box
in the code so that my Access app could find it and put in the appropriate
value. My user could hit the web form's "submit" button manually.

If anyone could point me in the right direction I'd appreciate it.

Thanks very much,

Keith


0
Reply Keith 1/2/2008 4:30:25 PM

The WinHttpRequest object is pretty useful if you want to pretend you are a 
web browser.  You need a reference to Microsoft WinHTTP Services.

Unfortunately you will probably need to do a bit of sleuthing in that web 
page's source to figure out exactly what to post.

"Keith G Hicks" <krh@comcast.net> wrote in message 
news:OrC$MzVTIHA.5516@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I have a client that frequently copies and pastes a couple dozen fields 
> from
> an MS Access form to a government web form (I don't know the URL at this
> time so I cannot provide that info here). I created the Access app for 
> him.
> The web form is NOT something we have access to other than the fact that
> they can log in and fill in the information needed. I did not write the 
> web
> app, nor did anyone in my client's office. We have no access to modify the
> behavior of the web form. In addition, I am not a web developer.
>
> I'd like to put a button on one of the forms in our MS Access app that 
> would
> automatically copy and paste certain fields from the MS Access app into 
> the
> already open web form just to save them the trouble of doing the 
> copy/paste
> process repeatedly. It seems to me that this should be possible via some
> sort of Windows API or something like that. If I view the source of a web
> page that has something that I can fill in (the box in the middle of the
> page www.google.com for example) it seems that I could identify the text 
> box
> in the code so that my Access app could find it and put in the appropriate
> value. My user could hit the web form's "submit" button manually.
>
> If anyone could point me in the right direction I'd appreciate it.
>
> Thanks very much,
>
> Keith
>
> 


0
Reply Baz 1/2/2008 4:54:36 PM

1 Replies
537 Views

(page loaded in 0.152 seconds)


Reply: