Importing Hyperlinks into Access table

[Aron McDermott via AccessMonster.com]

I'm importing HTML into an Access table and then allowing the user to view
this data through text boxes on a FORM. The HTML tags are currently being
stripped out. At times the HTML that's being imported in has HTML
bookmarks in them, where you click on a link and it takes you to a section
further down on the page.
For example the HTLM comes in as: <a href="#00454">Western Mexico - Sonora,
Baja California Norte, Baja California Sur</a>. This link would take you
to the following info further down on the HTML page: <a
name="00454">United Government Services Contractor# 00454</a></h4>(Sonora,
Baja California Norte, Baja California Sur). The user wants to be able to
use this functionality within the FORM of the Access application. One
issue is that the first part of the HTML may be in one text box and the
other may be in another text box. Is there any way to do this within
Access? I hope I've explained this well enough. If there are any
questions, please let me know and I'll answer them. I really appreciate
any help I can get.

Thank you in advace.

 

[Tim Ferguson]

Is there any way to do this within Access?

Indirect help only, I'm afraid. There is an Internet Explorer control that
you can place on your form and embed the whole html-parsing stuff: I
haven't used it since my VB5 days, but it should be doable.

This page might help:

<http://www.vbwm.com/art_2001/IE05/>

For an alternative, try this website:

<http://www.iol.ie/~locka/mozilla/control.htm>


Hope that helps


Tim F

 

[Aron McDermott via AccessMonster.com]

Thanks Tim. I'm not sure if that will work but I will give it a try.
Thanks for your help.