Fill In Web Page From Access

[IC_Clearly]

I want to have Access pull up a web page and fill out a form on a web page
from certain data in the db. Can someone point me in a direction of how to
do this? Is there a utility that can do this?

Thanks.

 

[Guest]

I asked that very question about 2 wks ago, sadly from what I've been told it
cannot be done.

If ever you discover a way, please post your solution (I will do the same).

Daniel P

 

[IC_Clearly]

Daniel,

I will post if I find something. I can't believe no one has done this! I
have had discussion with a fairly experienced Access programmer and he says
that he can do it using the send key function. But, if there is a package
that already does it, I would prefer to go that route as opposed to
developing from scratch.

 

[Douglas J. Steele]

I question how experienced that developer is, since SendKey is not a
reliable approach for anything. It's too easy for focus to get shifted while
the code is running, meaning that whatever keystrokes are being sent will
not end up where you want them.

 

[IC_Clearly]

Doug,

What would you recommend as an alternative??

 

[Douglas J. Steele]

In another thread on this topic which Daniel started elsewhere in these
forums, I suggested that it might be possible to use the Browser control to
put the web page on a form, and then use the IE DOM to address the
individual fields on that form (although I admitted that I haven't tried it
myself)

 

[IC_Clearly]

Thanks much. I'll see what I can come up with.