Results 1 to 7 of 7
  1. #1
    imran688 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    30

    Lightbulb auto fill a webform in webbrowsercontrol using access data


    Hi guys,
    There is a web browser control in my MS Access Form and i want to input the data from the access fields to web form in the browser control. Please help how to do it with the click of a button. I also want to copy certain data from the the webpage in the browser control into my access field.

    Imran

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Maybe this will be helpful:
    http://www.utteraccess.com/wiki/inde...Object_Library

    Review this thread on similar issue https://www.accessforums.net/program...-ie-28232.html

    Search for other threads started by redbull, is doing a lot with web pages.

    And http://bytes.com/topic/access/answer...m-open-website

    Don't know how this is done through webbrowser control. I expect issue of element names will be same. Must be a static reference. If the page is not designed to give the elements specific names, they will be different with each load of page.

    A variation of your issue:
    http://social.msdn.microsoft.com/For...9-0ba69df21e14
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    imran688 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    30
    I have seen it working on a person's pc a couple of years ago but i can not contact that person right now. All i need is to copy addresses to a web form who's elements name remain same even with page load.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Adapting from the referenced links, code might be something like:

    Dim HTML As HTMLDocument
    Set HTML = Me.WebBrowser0.Object.Document
    HTML.All.Items("item name").Value = "something"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    imran688 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    30
    Quote Originally Posted by June7 View Post
    Adapting from the referenced links, code might be something like:

    Dim HTML As HTMLDocument
    Set HTML = Me.WebBrowser0.Object.Document
    HTML.All.Items("item name").Value = "something"
    Can you please provide a working example? For example fill in the username and password in an example website like mail.google.com or facebook.com

  6. #6
    imran688 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    30
    Or just give me an example of auto login in facebook. I dont have to click any button or so, I just need to fill in the fields. Thanks

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    I don't have any working code. Never used browser control. Just cobbling together from the examples in links. I just tried to create browser control on form. It shows a url but not the page.

    From here I can only wish you luck because not finding any better references.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 12-21-2011, 02:11 PM
  2. Replies: 0
    Last Post: 09-29-2011, 11:52 AM
  3. Auto fill data (number) between tables
    By juli in forum Access
    Replies: 1
    Last Post: 08-31-2011, 10:41 PM
  4. Get access to update webform
    By phalore in forum Access
    Replies: 2
    Last Post: 06-06-2011, 04:15 PM
  5. Replies: 6
    Last Post: 04-14-2010, 11:03 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