Posted by Tom van Stiphout on 02/01/08 02:52

On Thu, 31 Jan 2008 18:57:56 GMT, jman (jcnone@none.com) wrote:

That's not quite the subject of this newsgroup, but I will try to
answer. It's not a simple project, and someone with "little
experience" will likely not be able to complete it.
If you want to use VBA you could create an Access form, have a
webbrowser control on it, and in code (or via a textbox) navigate to
your webpage. Then you need to use the DOM = Document Object Model to
find the input boxes and put values in them. E.g.:
WebBrowser1.Document.All("some_field").innerText = some_value
Getting the data out of the sql server is the easy part. You'd
probably run a query and capture the results in an ADO recordset.
You can also submit the page by calling the submit button's click
event:
WebBrowser1.Document.Forms(0)("Submit").Click

If the above is too much for you, hire professional help. "Microsoft
Solution Provider" in your Yellow Pages is a good place to start.

-Tom.


>Can anyone help me to transfer data results from a SQL query to
>input forms on a web page using vba or whatever will work. I work
>on a web page with forms that I need to populate with data. The web
>page is not mine and I have no control of the web page. My data
>comes from an SQL query and I want to code the transfer of the
>multiple data results into the web page form fields. I have little
>experience with VBA and SQL so please comment any code if possible.
>Thanks for your help.
>Jman

[Back to original message]