[AccessD] Web Page Error

Dale Kalsow dkalsow at yahoo.com
Mon Nov 4 10:11:47 CST 2013


 Set objCollection = IE.document.getElementsByTagName("input")
           i = 0
           While i < objCollection.Length
               If objCollection(i).Name = "ctl00$ctl00$MainContent$uxSearchWideControl$txtFirstName" Then
                   'objCollection(i).Value = ActiveSheet.Range("A1, A5").Value
                   objCollection(i).Value = strValue
                ElseIf objCollection(i).Name = "ctl00$ctl00$MainContent$uxSearchWideControl$txtLastName" Then
                    objCollection(i).Value = ActiveCell.Offset(0, 1).Value
               Set objCollection = IE.document.getElementsByTagName("a")
                       'If objCollection(i).href = "#" Then
                         'Set objElement = objCollection(i)
                       'End If
               Else
                   If objCollection(i).ID = "lnkSearch" And _
                      objCollection(i).Title = "Search" Then
                       Set objElement = objCollection(i)
                    End If
               End If
               i = i + 1
           Wend
           objElement.Click
           Do While IE.Busy
               Application.Wait DateAdd("s", 1, Now)
           Loop
           Application.Wait DateAdd("s", 3, Now)
           Set objCollection = IE.document.getElementsByTagName("p")
           i = 0: blnLoop = True: intI = objCollection.Length
           While blnLoop
                    If objCollection(i).classname = "NoResultsSummaryText" Then
                    IE.Quit
                    blnLoop = False
               End If
               i = i + 1
               If i >= intI Then blnLoop = False
           Wend


More information about the AccessD mailing list