Results 1 to 3 of 3
  1. #1
    phalore is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    2

    Get access to update webform

    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.

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Hi.
    Yes, this should be possible as I have done it using the following code:

    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

  3. #3
    phalore is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    2
    Thanks mate

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-22-2011, 12:23 PM
  2. Update not working in access
    By johnmerlino in forum Access
    Replies: 1
    Last Post: 10-10-2010, 06:00 PM
  3. How to update access table
    By ANDRE726 in forum Access
    Replies: 1
    Last Post: 01-27-2010, 04:26 AM
  4. Why won't Access update xml?
    By kyberspace in forum Access
    Replies: 0
    Last Post: 07-27-2009, 02:16 PM
  5. How To Update Access
    By zephaneas in forum Access
    Replies: 1
    Last Post: 11-08-2008, 10:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums