Creating hyperlinks in exported report

[Joe]

I have a table with hundreds of hyperlinks in one field (defined as a
hyperlink field) and a short name for each link in another field.

I can successfully export a report to HTML with the short name followed
by the hyperlink. What I would like to do is to combine the two so only
the short name is displayed.

In other words, I would like the output HTML to read:
<a href="http://www.webpage.com">ShortName</a>

I realize that I can do this by entering a "display name" in the link
field of the table but I have many hundreds of these and I would like
to not have to go back and modify each entry.

Is there a way to combine the fields in a query so the output is in the
correct format? Is it possible to construct it in the report itself? I
can't figure out how to get the required quote signs in there.
Thank you
Joe Donohue

[Salad]

Jo*@FormaExSilva.com wrote:

I have a table with hundreds of hyperlinks in one field (defined as a
hyperlink field) and a short name for each link in another field.

I can successfully export a report to HTML with the short name followed
by the hyperlink. What I would like to do is to combine the two so only
the short name is displayed.

In other words, I would like the output HTML to read:
<a href="http://www.webpage.com">ShortName</a>

I realize that I can do this by entering a "display name" in the link
field of the table but I have many hundreds of these and I would like
to not have to go back and modify each entry.

Is there a way to combine the fields in a query so the output is in the
correct format? Is it possible to construct it in the report itself? I
can't figure out how to get the required quote signs in there.
Thank you
Joe Donohue

Look at HyperlinkPart

I'll assume the Hyperlink field has the http.... stuff in it.

In a column in the querybuilder you could enter
Expr1 : "<a href=""" & HyperlinkPart([YourHyperlinkField],2) & ">" &
[YourShortNameField] & "</a>"

To test this out, you could open a form with the hyperlink and short
name fields in it, quickly create a command button and drop the
following into the OnClick event

Msgbox "<a href=""" & HyperlinkPart([YourHyperlinkField],2) & ">" &
[YourShortNameField] & "</a>"

Click on the button. If the string is correct, you are in good shape to
put it in the query. Simply remove the code and button when satisfied.

[Joe]

Salad, thank you for that information. Your query field produces
exactly the correct output. However, when exported to html, access
replaces the special symbols with their "&__;" equivalents and the
browsers (Netscape and IE) both do not render as hyperlinks.

Here is what I mean:

The output field from the query is:
<a href="http://www.righteouswoods.net/">All Righteous Woods</a>
which looks exactly correct.

On the report, it looks the same as above.

When exported to html, it shows up as:
&lt;a href=&quot;http://www.righteouswoods.net/&quot;&gt;All Righteous
Woods&lt;/a&gt;

I thought this should work correctly but it gets rendered not as a link
but as:
<a href="http://www.righteouswoods.net/">All Righteous Woods</a>

If I edit the html file, changing the "&lt;" to "<" and the "&gt;" to
">", it works correctly, yielding a proper link.

This surprised me. I thought you could always specify the special
characters this way but apparently you cannot, at least not with the
anchor tag.

Any idea how to cope with this? Am I doing something wrong?
I really appreciate the help.

Joe

[Salad]

Jo*@FormaExSilva.com wrote:

Salad, thank you for that information. Your query field produces
exactly the correct output. However, when exported to html, access
replaces the special symbols with their "&__;" equivalents and the
browsers (Netscape and IE) both do not render as hyperlinks.

Here is what I mean:

The output field from the query is:
<a href="http://www.righteouswoods.net/">All Righteous Woods</a>
which looks exactly correct.

On the report, it looks the same as above.

When exported to html, it shows up as:
&lt;a href=&quot;http://www.righteouswoods.net/&quot;&gt;All Righteous
Woods&lt;/a&gt;

I thought this should work correctly but it gets rendered not as a link
but as:
<a href="http://www.righteouswoods.net/">All Righteous Woods</a>

If I edit the html file, changing the "&lt;" to "<" and the "&gt;" to
">", it works correctly, yielding a proper link.

This surprised me. I thought you could always specify the special
characters this way but apparently you cannot, at least not with the
anchor tag.

Any idea how to cope with this? Am I doing something wrong?
I really appreciate the help.

Joe

Could you explain this about exporting to html? You are doing this from
a report? Or are you using Docmd.TransferText? Could you step me
through the process...don't need lots of detail, but enough to
understand your steps? That way I could create a table with your line,
export it, and understand what you are experiencing.