Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Alright, you will see in the code where we are stuck. If time allows today I will search for an alternative site to scrub data from..

    If there was a way to search without getting multiple results, we could turn

    oIE.Visible = True



    to

    oIE.Visible = False

    and just run the process without having IE "open" at all. Either way give the little app a spin. And don't judge my taste in movies and shows lol.

    MovieProject (3).zip
    Last edited by redbull; 08-08-2012 at 07:09 AM. Reason: Wrong attachment

  2. #17
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Update to the Multiple results message, a simple loop
    Code:
    ''Multiple Search Results
          If InStr(ImDb.Document.Body.innertext, "Popular Titles") > 0 Then
          ImDb.Navigate "javascript:alert('Multiple Results, Please select one.');"
          Do Until InStr(ImDb.Document.Body.innertext, "Stars") > 0
          DoEvents
          PauseApp 1
         Loop
         End If

  3. #18
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Ran the app and it does open site to the film info page.

    I noticed a couple of misspellings in film titles:

    Missing r
    A Nightmare on Elm Street 3: Dream Warriors

    Extra c
    Alvin and the Chipmuncks
    Alvin and the Chipmuncks: The Squeakquel
    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.

  4. #19
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    lol my wife entered all of the movie names, I personally am not that organized. So I am looking for a different site I suppose that I can pull the information I want out. One of these days I will find that magic site lol.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Side-by-Side Fields
    By DEG in forum Queries
    Replies: 1
    Last Post: 07-25-2011, 04:41 PM
  2. Replies: 11
    Last Post: 07-20-2011, 11:28 AM
  3. Side-by-side incorrect configuration
    By jbon in forum Access
    Replies: 1
    Last Post: 04-12-2011, 06:41 PM
  4. same recordset subreport side by side
    By novreis in forum Reports
    Replies: 5
    Last Post: 02-16-2011, 04:21 PM
  5. Multiple records side by side
    By Patience in forum Reports
    Replies: 8
    Last Post: 09-01-2010, 09:17 AM

Tags for this Thread

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