Hey guys,
I'm trying to open a webpage from VB and fill in a form on that page with values from a database. I'm using VBA from Access 2003. This is where im at right now (not very far...im still a beginner to VB):
Referencing the Microsoft Internet Controls lib.
[CODE=vb]Public Sub Command0_Click( )
Dim webBrowser1 As WebBrowser
Dim findString As String
Set webBrowser1 = New WebBrowser
Set webBrowser1 = CreateObject("I nternetExplorer .Application")
webBrowser1.Nav igate2 "http://www.webaddress. com"
webBrowser1.Vis ible = True
Do
DoEvents
Loop Until Not webBrowser1.Bus y
End Sub[/CODE]
i know i need to look at the HTML source code of the webpage to reference the fields on the form, i just dont know how to code this. Can anyone help with this?
Thanks.
I'm trying to open a webpage from VB and fill in a form on that page with values from a database. I'm using VBA from Access 2003. This is where im at right now (not very far...im still a beginner to VB):
Referencing the Microsoft Internet Controls lib.
[CODE=vb]Public Sub Command0_Click( )
Dim webBrowser1 As WebBrowser
Dim findString As String
Set webBrowser1 = New WebBrowser
Set webBrowser1 = CreateObject("I nternetExplorer .Application")
webBrowser1.Nav igate2 "http://www.webaddress. com"
webBrowser1.Vis ible = True
Do
DoEvents
Loop Until Not webBrowser1.Bus y
End Sub[/CODE]
i know i need to look at the HTML source code of the webpage to reference the fields on the form, i just dont know how to code this. Can anyone help with this?
Thanks.