Results 1 to 2 of 2
  1. #1
    kryadan is offline Novice
    Windows XP Access 2000
    Join Date
    Oct 2010
    Posts
    1

    ie object fill in web textbox on website with Frames

    Hey all,



    The point of this project is for our customer service to click a button and that will open the website with the corporate name and username filled in for them, all they need to do is type in their password. I can automate filling in a textbox on a website like google that doesn't use frames, but when the site uses frames I'm stumped. Below are examples.

    To open a website and pre-fill a textbox is no problem on a site with no frames (google in this example):

    Code:
    Dim ie As InternetExplorer
    Set ie = New InternetExplorer
    ie.Visible = True
    ie.Navigate http://www.google.com 
    ie.Document.getElementById("q").value = "My Search Text"
    My problem occurs on the website https://www.beanstream.com/Admin/sDefault.asp where frames are used. Not certain how to navigate through the Ie object when there are frames present.

    I've used the debugger to try and go through my ie object to find the textbox name (<INPUT type="textbox" NAME="merchantName" id="merchantName">) but I just can't seem to figure out how to get through it with the Frames.

    Any help at all would be great!

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    are you telling us that this code:
    Code:
    <TD><FONT SIZE=2 FACE="arial">Company:</FONT></TD>
    
    						<TD><INPUT type="textbox" NAME="merchantName" id="merchantName"
    becomes irrelevant when it's put inside of a frame or iframe? so the 'getElementById' syntax in access VBA does not work. is that what you're saying?

    Frames are something that I have not figured out either, but I would assume they are enumerated on the page, just like everything else. Have you tried something to the effect of:
    Code:
    internetexplorer.frames(0).controls("merchantname").value = "your input"
    ??

    The other thing to consider also, if you're going to reference an enumeration like that, is to know that javascript generally references array elements and enumerations with brackets [], so it is quite possible that the following would yield some result:
    Code:
    internetexplorer.frames[0].controls("merchantname").value = "your input"
    I don't know really, but it's worth a try for sure.

    One more thing too...where I used "controls", I don't think that would be the right collection. It is not the same as the controls collection in VBA. It would be called something else. Maybe try substituting the 'getElement' js code in there?

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

Similar Threads

  1. Replies: 3
    Last Post: 11-02-2010, 10:14 AM
  2. Linking dbase with website
    By pp100 in forum Database Design
    Replies: 2
    Last Post: 08-24-2010, 05:56 AM
  3. Replies: 1
    Last Post: 08-05-2010, 12:11 PM
  4. Open website from list box
    By kev921hs in forum Programming
    Replies: 4
    Last Post: 05-24-2010, 01:43 AM
  5. Retrieving data on my website
    By kattys in forum Access
    Replies: 1
    Last Post: 04-27-2010, 05:02 PM

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