fill online forms using Access

[live2ride]

ok i found a problem, if i put
ie.Document.all.Item("searchcriteria").Value = "test" (this works)
im assuming the above works because text SearcCriteria is at the top slightly below the body, but the fields i need to get to are way down the tree, something like
html/body/table/tbody/tr/td/div/span/table/tbody/tr/td/span/table/tbody/tr/td/table/tbody/tr/td/table/tr/td/tdbody/ and few more of these before i get to div where this text box is located
although "Title" seems to be the only field in html, it doesnt work when i say all.item("title")


any suggestions?

as for your trim issue i tried
Dim strXX As String
strXX = ImDb.Document.itemprop("description")
MsgBox strXX
and im only getting error "Object doesnt support this property or method"

[live2ride]

i just explained trimming on the other post, if you got any questions let me know, lol with all the trimming i had to do i think i became a pro hehe

[live2ride]

i got most things to work on another website anyway using
dim str as string
set str = "blah"
ie.document.all.item("" & str & "").value = myValue

problem with this site i encountered is that this is a drop down box and although i was able to use above method to do values to most drop downs, one drop down in particular is giving me an issue
perhaps because the other drop downs are strings and this one is integer?

issue is when i try to submit i get error on website "Value is not among the set of valid lookup values."

in access anyway there are two methods of values in drop down, using the ID and using the actual value and i have no idea which one is this

any suggestions?

[live2ride]

i need to click this button
<INPUT onclick="btncheck2(this,15109)" align="" type="checkbox" formflag="true" value="on" />

unfortunately when i use
ie.Document.parentWindow.execScript ("btncheck2(this, 15109)")
i get error Access Denied, any ideas?

[live2ride]

due to security issues we can not call function in within ie so to bypass this sendkeys had to be called

however i have another issue
input id="x-auto-25-input" class=" x-form-field x-form-text" type="text" tabindex="0" name="" _id="R_Destination" style="width: 695px
the above code uses ID and _ID, while ID is auto assigned it is very inreliable, and the "_ID" is static. does anyone know how i can use "_id" field?

[redbull]

you can use tags... its a nifty trick i just learned ....the "tag" is the html element, like table, or td,div,etc etc... if I can snag the bit of html at the start of that string i can isolate it further... but fiddle around with this!

debug.print oie.document.all.tag"table".item(1).innertext
this might work too...
debug.print oie.document.all.tag"input".item(1).innertext

open the immediate window to see what /\ item is....

If your page does not have any tables, then try div or something... once you isolate the item your trying to interact with... you can go back to the good old .click or .submit but the trick is FINDING what your wanting to tickle. Once you do, you can use it and abuse it as normal.

oie.document.all.tag"table".item(1).click

This way you can interact with full tables of data, OR interact with things there the ID or name is not an option. Glad to see someone else is using vba for oie automation. It gets REALLY interesting.

You can also very easily pull in entire tables into your form, if you have a need for that or not... its a cool trick.

[redbull]

the thing you will want to change is the item number, as it just gives you the item number in the html.

debug.print oie.document.all.tag"table".item(1).innertext
will show you the first table item on the webpage. So you will have to randomly go thru until you find the element your looking for. VBA can be a fickle bitch though... I am currently trying to initiate a checkbox on a website, that is in a table data type format... and it is impossibru. here is what I am trying to do.. maybe some fresh eyes will help...

oie.document.all.tag"td".item(39) <~ this is a sincle checkmark listed on a table on the website.. so I am trying to change its value... and these are the things I have tried...

with oie.document.all.tag"td".item(39)
.click
.submit
.checked = True
.value = xx
.check
.im going to loose it
.AHHH
end with

Yea, so for a check mark.... none of these worked... and I am out of ideas at this point... banging my head against my desk now...

[live2ride]

i posted a question on StackOverflo, Tim there was very helpful. check it out