rendering DOM in MS access shodocvw

[Asif Rehman]

A while ago, I've worked with DOM in MS access, but now I've no idea how to navigate, and get particular element's value, on documentcomplete like events. Is there any file you can refer to that has all the basic of DOM to play with web pages in MS Access VBA.

Thanks
Asif Rehman

[Jim Doherty]

@Asif Rehman
Are you an Access developer or webpage designer? are you wanting to expose ie: MS HTML object library amongst other? if so then open a module window in access and set a reference (tools..references) to the particular object model and look at them using the object browser (another reference is Microsoft Internet Controls (shodocvw) which expose its object methods.

Below is a functional example (without setting a reference given we are creating an instance of the object) of Access calling to a webpage such as this site, inserting the values for a query search which is returned (within the site) via an internet explorer page.

Call it like this .....GotoBytes("Querydefs")

Function GoToBytes(strquestion As String)
Dim iex As Object
Dim iexPage As Object
Set iex = CreateObject("internetexplorer.application")
iex.Visible = True
iex.Navigate "http://www.bytes.com"
    While iex.busy
      DoEvents
    Wend
iex.Document.all("query").Value = strquestion
iex.Document.all("gobutton").Click
    While iex.busy
      DoEvents
    Wend
Set iex = Nothing
End Function