Using a web browser control

R

Rob Oldfield

Can I just add that I think that "My family and other animals" is an abysmal
book? Could we try searching for something a little better?


Douglas J. Steele said:
Hey, it worked really well!

Create a form and add a Web Browser to it (you can use the Insert | ActiveX
Control... from the menu, and scroll through until you find the Microsoft
Web Browser entry) I chose to rename the control ocxBrowser.

Add code to navigate to the URL. I chose to add a button, cmdGotoURL, with
the following code:

Private Sub cmdGotoURL_Click()
On Error GoTo Err_cmdGotoURL_Click

Dim strURL As String

strURL =
"http://www.loc.gov/cgi-bin/zgate?ACTION=INIT&FORM_HOST_PORT=/prod/www/data/
z3950/locils1.html,z3950.loc.gov,7090&CI=121347"
Me.ocxBrowser.Navigate strURL

End_cmdGotoURL_Click:
Exit Sub

Err_cmdGotoURL_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGotoURL_Click"
Resume End_cmdGotoURL_Click

End Sub

Add another button cmdGetHTML with the following code:

Private Sub cmdGetHTML_Click()
On Error GoTo Err_cmdGetHTML_Click

Debug.Print Me.ocxBrowser.Document.documentElement.innerText

End_cmdGetHTML_Click:
Exit Sub

Err_cmdGetHTML_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGetHTML_Click"
Resume End_cmdGetHTML_Click

End Sub

Fire up the form, and click on the cmdGotoURL button. That'll bring up the
Library of Congress search form in the browser you put on the form. Enter
"My family and other animals" in the Search Terms box, then click on the
Submit Query button. The results will appear on the browser. Click on the
cmdGetHTML button, then look in the Debug window. You should see:

VOYAGER[my family and other animals[1,4,2,3,3,1,4,1,5,1,6,1]]Query Results
Records 1 through 3 of 3 returned.


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: New York, Viking Press, 1957 [c1956]
LC Call No.: QH151.D8 1956a

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: London, Hart-Davis, 1956
LC Call No.: QH151.D8 1956

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals / Gerald Durrell.
Published: New York : Penguin Books, 2000.
LC Call No.: QH151.D8 2000

More on this record

Go back to the Search Form

This display was generated by the CNIDR Web-Z39.50 gateway, version 1.08,
with Library of Congress Modifications.

Hopefully you can parse that however you want.

Since this page uses the POST method to navigate to the next form, you could
probably use the concepts presented in
http://support.microsoft.com/?id=167658 to be able to do everything
programmatically (as opposed to having to key the information into the
browser and click on the Submit button). Sorry, too lazy to look into that
right now.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Fred Boer said:
What!? I thought you'd be done by now! ;)

Seriously, please don't spend any more time or effort on this than you
want, Doug! I'm in no hurry, and, well, it isn't mission critical. And as
far as my wife and kids are concerned it ain't even mission necessary!!

Fred
Click to expand...
Click to expand...
 
R

Rob Oldfield

Fred. You really do have something *seriously* wrong with your clock.


Fred Boer said:
Dear Doug:

That sounds great! I can't work on it tonight (got to help my kids with
their homework... what the *heck* is a Least Common Multiple??!!.. Prime
factorial??! Two Venn diagrams??... argh! I cannot do Grade 8 math!... ),
but I am looking forward to trying it out tomorrow. Oh, boy, that will be a
slick feature! I'll keep you informed on my progress and if I have any
questions. Thank you very much for your help!

All the best,
Fred

Douglas J. Steele said:
Hey, it worked really well!

Create a form and add a Web Browser to it (you can use the Insert | ActiveX
Control... from the menu, and scroll through until you find the Microsoft
Web Browser entry) I chose to rename the control ocxBrowser.

Add code to navigate to the URL. I chose to add a button, cmdGotoURL, with
the following code:

Private Sub cmdGotoURL_Click()
On Error GoTo Err_cmdGotoURL_Click

Dim strURL As String

strURL =
Click to expand...
"http://www.loc.gov/cgi-bin/zgate?ACTION=INIT&FORM_HOST_PORT=/prod/www/data/
z3950/locils1.html,z3950.loc.gov,7090&CI=121347"
Me.ocxBrowser.Navigate strURL

End_cmdGotoURL_Click:
Exit Sub

Err_cmdGotoURL_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGotoURL_Click"
Resume End_cmdGotoURL_Click

End Sub

Add another button cmdGetHTML with the following code:

Private Sub cmdGetHTML_Click()
On Error GoTo Err_cmdGetHTML_Click

Debug.Print Me.ocxBrowser.Document.documentElement.innerText

End_cmdGetHTML_Click:
Exit Sub

Err_cmdGetHTML_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGetHTML_Click"
Resume End_cmdGetHTML_Click

End Sub

Fire up the form, and click on the cmdGotoURL button. That'll bring up the
Library of Congress search form in the browser you put on the form. Enter
"My family and other animals" in the Search Terms box, then click on the
Submit Query button. The results will appear on the browser. Click on the
cmdGetHTML button, then look in the Debug window. You should see:

VOYAGER[my family and other animals[1,4,2,3,3,1,4,1,5,1,6,1]]Query Results
Records 1 through 3 of 3 returned.


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: New York, Viking Press, 1957 [c1956]
LC Call No.: QH151.D8 1956a

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: London, Hart-Davis, 1956
LC Call No.: QH151.D8 1956

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals / Gerald Durrell.
Published: New York : Penguin Books, 2000.
LC Call No.: QH151.D8 2000

More on this record

Go back to the Search Form

This display was generated by the CNIDR Web-Z39.50 gateway, version 1.08,
with Library of Congress Modifications.

Hopefully you can parse that however you want.

Since this page uses the POST method to navigate to the next form, you could
probably use the concepts presented in
http://support.microsoft.com/?id=167658 to be able to do everything
programmatically (as opposed to having to key the information into the
browser and click on the Submit button). Sorry, too lazy to look into that
right now.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Fred Boer said:
What!? I thought you'd be done by now! ;)

Seriously, please don't spend any more time or effort on this than you
want, Doug! I'm in no hurry, and, well, it isn't mission critical. And as
far as my wife and kids are concerned it ain't even mission necessary!!

Fred



Don't get too hopeful, though, Fred!

I'm still on Access 97 at the office, and I've fallen victim to the bug
in
http://support.microsoft.com/?id=177105

I'll try at home tonight with Access 2003....

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Thanks, Doug!

Fred

Actually, Fred, having looked at the example you just gave, I think
you
will
have to use the Browser control.

I'm going to play around with it a little while. I'll post back here
later
today.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dear Dirk:

Thanks for the link. I will take a look at it. In another thread,
Doug
Steele suggested the approach listed in one of his SmartAccess
columns
(http://www.accessmvp.com/DJSteele/SmartAccess.html November
Click to expand...
Click to expand...
2003).
I
Click to expand...
http://www.loc.gov/cgi-bin/zgate?AC...950/locils1.html,z3950.loc.gov,7090&CI=121347
Click to expand...
 
F

Fred Boer

Ok. I need an old priest and a young priest. And lots of holy water. Oh, and
maybe a mop for the mess on the floor...

I post from 2 different computers... I am afraid. Very afraid.

I am genuinely sorry to have yet again, posted with a future time/date! I
will quadruple check each machine before I post.

Fred

Rob Oldfield said:
Fred. You really do have something *seriously* wrong with your clock.


Fred Boer said:
Dear Doug:

That sounds great! I can't work on it tonight (got to help my kids with
their homework... what the *heck* is a Least Common Multiple??!!.. Prime
factorial??! Two Venn diagrams??... argh! I cannot do Grade 8 math!... ),
but I am looking forward to trying it out tomorrow. Oh, boy, that will
Click to expand...
be
a
slick feature! I'll keep you informed on my progress and if I have any
questions. Thank you very much for your help!

All the best,
Fred
Click to expand...
"http://www.loc.gov/cgi-bin/zgate?ACTION=INIT&FORM_HOST_PORT=/prod/www/data/
z3950/locils1.html,z3950.loc.gov,7090&CI=121347"
Me.ocxBrowser.Navigate strURL

End_cmdGotoURL_Click:
Exit Sub

Err_cmdGotoURL_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGotoURL_Click"
Resume End_cmdGotoURL_Click

End Sub

Add another button cmdGetHTML with the following code:

Private Sub cmdGetHTML_Click()
On Error GoTo Err_cmdGetHTML_Click

Debug.Print Me.ocxBrowser.Document.documentElement.innerText

End_cmdGetHTML_Click:
Exit Sub

Err_cmdGetHTML_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGetHTML_Click"
Resume End_cmdGetHTML_Click

End Sub

Fire up the form, and click on the cmdGotoURL button. That'll bring up the
Library of Congress search form in the browser you put on the form. Enter
"My family and other animals" in the Search Terms box, then click on the
Submit Query button. The results will appear on the browser. Click on the
cmdGetHTML button, then look in the Debug window. You should see:

VOYAGER[my family and other animals[1,4,2,3,3,1,4,1,5,1,6,1]]Query Results
Records 1 through 3 of 3 returned.


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: New York, Viking Press, 1957 [c1956]
LC Call No.: QH151.D8 1956a

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: London, Hart-Davis, 1956
LC Call No.: QH151.D8 1956

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals / Gerald Durrell.
Published: New York : Penguin Books, 2000.
LC Call No.: QH151.D8 2000

More on this record

Go back to the Search Form

This display was generated by the CNIDR Web-Z39.50 gateway, version 1.08,
with Library of Congress Modifications.

Hopefully you can parse that however you want.

Since this page uses the POST method to navigate to the next form, you could
probably use the concepts presented in
http://support.microsoft.com/?id=167658 to be able to do everything
programmatically (as opposed to having to key the information into the
browser and click on the Submit button). Sorry, too lazy to look into that
right now.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



What!? I thought you'd be done by now! ;)

Seriously, please don't spend any more time or effort on this than you
want, Doug! I'm in no hurry, and, well, it isn't mission critical.
Click to expand...
And
as
far as my wife and kids are concerned it ain't even mission necessary!!

Fred



Don't get too hopeful, though, Fred!

I'm still on Access 97 at the office, and I've fallen victim to the bug
in
http://support.microsoft.com/?id=177105

I'll try at home tonight with Access 2003....

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Thanks, Doug!

Fred

Actually, Fred, having looked at the example you just gave, I think
you
will
have to use the Browser control.

I'm going to play around with it a little while. I'll post back here
later
today.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dear Dirk:

Thanks for the link. I will take a look at it. In another thread,
Doug
Steele suggested the approach listed in one of his SmartAccess
columns
(http://www.accessmvp.com/DJSteele/SmartAccess.html November
Click to expand...
2003).
I
could
be mistaken, but I wonder if your suggestion will present the same
difficulty that I believe exists with Doug's suggestion: it is
assumed
that
the URL is known before the process begins. In my situation,
Click to expand...
the
URL
will
change in each instance. If it won't bore you, perhaps I might
outline
what
I "really want to do".. ;)

I want to retrieve book cataloguing information from the
Click to expand...
Click to expand...
Library
of
Click to expand...
http://www.loc.gov/cgi-bin/zgate?AC...950/locils1.html,z3950.loc.gov,7090&CI=121347
to
it
Click to expand...
since
I
Click to expand...
Click to expand...
 
F

Fred Boer

Oooh. Houston we have a problem. Rob, if I ever by chance I get to meet you,
I would be honoured to buy you a beer, and raise my glass in a toast to your
health and well being. However, "My Family and Other Animals", and the other
Gerald Durrel. books are among my most favourite books. So, with all
respect, I must disagree with your assessment most strenuously!

Perhaps you could make a suggestion? I'm sure there is some common ground
here...

How about James Herriot? Douglas Adams? John Le Carre? Frank Herbert? Robert
Heinlein? Tolkien? Bill Bryson? Anything here we could agree on? All
favourites of mine...

Cheers!
Fred

Rob Oldfield said:
Can I just add that I think that "My family and other animals" is an abysmal
book? Could we try searching for something a little better?


Douglas J. Steele said:
Hey, it worked really well!

Create a form and add a Web Browser to it (you can use the Insert | ActiveX
Control... from the menu, and scroll through until you find the Microsoft
Web Browser entry) I chose to rename the control ocxBrowser.

Add code to navigate to the URL. I chose to add a button, cmdGotoURL, with
the following code:

Private Sub cmdGotoURL_Click()
On Error GoTo Err_cmdGotoURL_Click

Dim strURL As String

strURL =
Click to expand...
"http://www.loc.gov/cgi-bin/zgate?ACTION=INIT&FORM_HOST_PORT=/prod/www/data/
z3950/locils1.html,z3950.loc.gov,7090&CI=121347"
Me.ocxBrowser.Navigate strURL

End_cmdGotoURL_Click:
Exit Sub

Err_cmdGotoURL_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGotoURL_Click"
Resume End_cmdGotoURL_Click

End Sub

Add another button cmdGetHTML with the following code:

Private Sub cmdGetHTML_Click()
On Error GoTo Err_cmdGetHTML_Click

Debug.Print Me.ocxBrowser.Document.documentElement.innerText

End_cmdGetHTML_Click:
Exit Sub

Err_cmdGetHTML_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGetHTML_Click"
Resume End_cmdGetHTML_Click

End Sub

Fire up the form, and click on the cmdGotoURL button. That'll bring up the
Library of Congress search form in the browser you put on the form. Enter
"My family and other animals" in the Search Terms box, then click on the
Submit Query button. The results will appear on the browser. Click on the
cmdGetHTML button, then look in the Debug window. You should see:

VOYAGER[my family and other animals[1,4,2,3,3,1,4,1,5,1,6,1]]Query Results
Records 1 through 3 of 3 returned.


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: New York, Viking Press, 1957 [c1956]
LC Call No.: QH151.D8 1956a

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: London, Hart-Davis, 1956
LC Call No.: QH151.D8 1956

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals / Gerald Durrell.
Published: New York : Penguin Books, 2000.
LC Call No.: QH151.D8 2000

More on this record

Go back to the Search Form

This display was generated by the CNIDR Web-Z39.50 gateway, version 1.08,
with Library of Congress Modifications.

Hopefully you can parse that however you want.

Since this page uses the POST method to navigate to the next form, you could
probably use the concepts presented in
http://support.microsoft.com/?id=167658 to be able to do everything
programmatically (as opposed to having to key the information into the
browser and click on the Submit button). Sorry, too lazy to look into that
right now.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Fred Boer said:
What!? I thought you'd be done by now! ;)

Seriously, please don't spend any more time or effort on this than you
want, Doug! I'm in no hurry, and, well, it isn't mission critical. And as
far as my wife and kids are concerned it ain't even mission necessary!!

Fred



Don't get too hopeful, though, Fred!

I'm still on Access 97 at the office, and I've fallen victim to the bug
in
http://support.microsoft.com/?id=177105

I'll try at home tonight with Access 2003....

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Thanks, Doug!

Fred

Actually, Fred, having looked at the example you just gave, I think
you
will
have to use the Browser control.

I'm going to play around with it a little while. I'll post back here
later
today.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dear Dirk:

Thanks for the link. I will take a look at it. In another thread,
Doug
Steele suggested the approach listed in one of his SmartAccess
columns
(http://www.accessmvp.com/DJSteele/SmartAccess.html November
Click to expand...
Click to expand...
2003).
I
Click to expand...
http://www.loc.gov/cgi-bin/zgate?AC...950/locils1.html,z3950.loc.gov,7090&CI=121347
Click to expand...
 
F

Fred Boer

Hello!

Well, I've been doing a bit 'o research about using web pages as a source of
book cataloguing data, and I found an example of a form which uses a "Web
Browser Control". Well, I've never heard of such a thing but it looks
interesting. I was easily able to stick a control on a form and have it
display a web page. But I can't recall *ever* seeing a post that mentions
this control...

1. Has anybody used this control?
2. Why have I never seen any posts relating to its use?
3. Is is a good/bad thing?
4. I see it is an Active X control - that's a bad thing 'cause it leads to
DLL issues? Right? or is that overstating things...
5. Any particular hints/suggestions/cautions about such a control?

Thanks!
Fred Boer
 
F

Fred Boer

Dear Amy:

Thanks for the suggestions. Hmm... $3K... <g> Well, they once gave me enough
money to actually buy a copy of the Access Developer's Handbook... but I had
to threaten to stop giving the secretaries free tech support for Excel and
Word... That was about $100.00... Naw, I don't think it'll happen! ;) Of
course, you have no way of knowing, but my application is for a small school
library that serves blind/visually impaired students. I've built it with
Microsoft donated software, mostly in my spare time. There is no budget
associated with this project.

BTW... I liked the Saniquarium on your site. I was looking at it and a
couple of my students were taken aback and asked me what the heck I was
doing with buckets of water in my office...

Cheers!
Fred
 
F

Fred Boer

Of course, the sound of all that rippling water quickly sent me scurrying to
the washroom! ;)

Fred
 
F

Fred Boer

Hi Doug:

Well, is that ever neat! Thanks *so* much! It looks very slick and
professional! I can set up different command buttons to take me to different
library catalogue sites, and with a click of a button, I have the
cataloguing data! And it looks really clean and neat, as well. (I happen to
like that there is no button bar, or toolbar to complicate the screen, just
a box with a functional website inside...) I've created a form, with
buttons, and am about to work on the parsing...

Of course, I'd never have done this without your help, Doug! Many thanks!

Fred

Douglas J. Steele said:
Hey, it worked really well!

Create a form and add a Web Browser to it (you can use the Insert |
ActiveX Control... from the menu, and scroll through until you find the
Microsoft Web Browser entry) I chose to rename the control ocxBrowser.

Add code to navigate to the URL. I chose to add a button, cmdGotoURL, with
the following code:

Private Sub cmdGotoURL_Click()
On Error GoTo Err_cmdGotoURL_Click

Dim strURL As String

strURL =
"http://www.loc.gov/cgi-bin/zgate?AC...950/locils1.html,z3950.loc.gov,7090&CI=121347"
Me.ocxBrowser.Navigate strURL

End_cmdGotoURL_Click:
Exit Sub

Err_cmdGotoURL_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGotoURL_Click"
Resume End_cmdGotoURL_Click

End Sub

Add another button cmdGetHTML with the following code:

Private Sub cmdGetHTML_Click()
On Error GoTo Err_cmdGetHTML_Click

Debug.Print Me.ocxBrowser.Document.documentElement.innerText

End_cmdGetHTML_Click:
Exit Sub

Err_cmdGetHTML_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGetHTML_Click"
Resume End_cmdGetHTML_Click

End Sub

Fire up the form, and click on the cmdGotoURL button. That'll bring up the
Library of Congress search form in the browser you put on the form. Enter
"My family and other animals" in the Search Terms box, then click on the
Submit Query button. The results will appear on the browser. Click on the
cmdGetHTML button, then look in the Debug window. You should see:

VOYAGER[my family and other animals[1,4,2,3,3,1,4,1,5,1,6,1]]Query Results
Records 1 through 3 of 3 returned.


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: New York, Viking Press, 1957 [c1956]
LC Call No.: QH151.D8 1956a

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: London, Hart-Davis, 1956
LC Call No.: QH151.D8 1956

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals / Gerald Durrell.
Published: New York : Penguin Books, 2000.
LC Call No.: QH151.D8 2000

More on this record

Go back to the Search Form

This display was generated by the CNIDR Web-Z39.50 gateway, version 1.08,
with Library of Congress Modifications.

Hopefully you can parse that however you want.

Since this page uses the POST method to navigate to the next form, you
could probably use the concepts presented in
http://support.microsoft.com/?id=167658 to be able to do everything
programmatically (as opposed to having to key the information into the
browser and click on the Submit button). Sorry, too lazy to look into that
right now.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Fred Boer said:
What!? I thought you'd be done by now! ;)

Seriously, please don't spend any more time or effort on this than you
want, Doug! I'm in no hurry, and, well, it isn't mission critical. And as
far as my wife and kids are concerned it ain't even mission necessary!!

Fred
Click to expand...
Click to expand...
 
F

Fred Boer

Dear Doug:

That sounds great! I can't work on it tonight (got to help my kids with
their homework... what the *heck* is a Least Common Multiple??!!.. Prime
factorial??! Two Venn diagrams??... argh! I cannot do Grade 8 math!... ),
but I am looking forward to trying it out tomorrow. Oh, boy, that will be a
slick feature! I'll keep you informed on my progress and if I have any
questions. Thank you very much for your help!

All the best,
Fred

Douglas J. Steele said:
Hey, it worked really well!

Create a form and add a Web Browser to it (you can use the Insert | ActiveX
Control... from the menu, and scroll through until you find the Microsoft
Web Browser entry) I chose to rename the control ocxBrowser.

Add code to navigate to the URL. I chose to add a button, cmdGotoURL, with
the following code:

Private Sub cmdGotoURL_Click()
On Error GoTo Err_cmdGotoURL_Click

Dim strURL As String

strURL =
"http://www.loc.gov/cgi-bin/zgate?ACTION=INIT&FORM_HOST_PORT=/prod/www/data/
z3950/locils1.html,z3950.loc.gov,7090&CI=121347"
Me.ocxBrowser.Navigate strURL

End_cmdGotoURL_Click:
Exit Sub

Err_cmdGotoURL_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGotoURL_Click"
Resume End_cmdGotoURL_Click

End Sub

Add another button cmdGetHTML with the following code:

Private Sub cmdGetHTML_Click()
On Error GoTo Err_cmdGetHTML_Click

Debug.Print Me.ocxBrowser.Document.documentElement.innerText

End_cmdGetHTML_Click:
Exit Sub

Err_cmdGetHTML_Click:
MsgBox Err.Number & ": " & Err.Description & vbCrLf & vbCrLf & _
"Occurred in cmdGetHTML_Click"
Resume End_cmdGetHTML_Click

End Sub

Fire up the form, and click on the cmdGotoURL button. That'll bring up the
Library of Congress search form in the browser you put on the form. Enter
"My family and other animals" in the Search Terms box, then click on the
Submit Query button. The results will appear on the browser. Click on the
cmdGetHTML button, then look in the Debug window. You should see:

VOYAGER[my family and other animals[1,4,2,3,3,1,4,1,5,1,6,1]]Query Results
Records 1 through 3 of 3 returned.


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: New York, Viking Press, 1957 [c1956]
LC Call No.: QH151.D8 1956a

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals.
Published: London, Hart-Davis, 1956
LC Call No.: QH151.D8 1956

More on this record


Author: Durrell, Gerald Malcolm, 1925-
Title: My family and other animals / Gerald Durrell.
Published: New York : Penguin Books, 2000.
LC Call No.: QH151.D8 2000

More on this record

Go back to the Search Form

This display was generated by the CNIDR Web-Z39.50 gateway, version 1.08,
with Library of Congress Modifications.

Hopefully you can parse that however you want.

Since this page uses the POST method to navigate to the next form, you could
probably use the concepts presented in
http://support.microsoft.com/?id=167658 to be able to do everything
programmatically (as opposed to having to key the information into the
browser and click on the Submit button). Sorry, too lazy to look into that
right now.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Fred Boer said:
What!? I thought you'd be done by now! ;)

Seriously, please don't spend any more time or effort on this than you
want, Doug! I'm in no hurry, and, well, it isn't mission critical. And as
far as my wife and kids are concerned it ain't even mission necessary!!

Fred
Click to expand...
Click to expand...
 
F

Fred Boer

Thanks! That's a neat training technique! However, it isn't really what I am
having trouble with - but I don't know the URL in advance...

Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

navigating the web browser control to a file 1
using ms web browser control 1
web browser control 3
Web Browser Control Problem ? 1
Problem with Access application using Web Browser Control 1
Web Browser Control Reference 2
Web Browser Control and Javascript 3
Events do not fire when assigning a value to a control using vba 3

Top