Get access to update webform

[phalore]

Hi,
I am brand new to the forum so 'Hello'. I am a IT Tech for a school and I am making a simple database to track student laptop repairs. To submit a repair request with the laptop manufacture (acer) I have to complete a webform from their website. All the info is duplicated in the database I am making for our own personal tracking needs. I was hoping it would be possible for me to enter the data into the DB I am writing and 'Hit' a button and have the info populate this external webform and then all I have to do is then submit.



I hope this makes sense.

Thanks.

[SoftwareMatters]

Hi.
Yes, this should be possible as I have done it using the following code:

 
Dim ie As Object, i_URL As String, GetNow As Date, WebAddress As String
Set ie = CreateObject("InternetExplorer.application")
If InStr(Me!ConsulteeID.Column(1), "www") > 1 Then
WebAddress = GetWebAddress
ie.Visible = True
ie.Navigate WebAddress 
Do Until ie.ReadyState = 4
Loop
ie.Document.getElementById("email").Value = GetEmail
End If

NB: The 'Document.getElementById("email")' bit refers to a control on the web form called "email" so add any controls as required. Aslo, don't forget to add the correct webaddress.
NB: You will need to add the web address and the any control names with the req

[phalore]

Thanks mate