Hi,
At least in Access 2003, if you have a Hyperlink field containing a
string formatted like this:
displaytext#address#subaddress
when you export to HTML it is converted into a HREF structure
<A HREF="address#subaddress">displaytext</A>
So the simplest thing may be to combine your two fields into one and
take advantage of this behaviour.
Otherwise, all I can think of involves hand-coding:
(a) write VBA code to generate custom HTML, or
(b) do a standard export to HTML and then have your code run through the
resulting file to modify the links as required.
On Tue, 26 Sep 2006 17:34:17 -0700, "MeTed" <meted[ at ]meted.com> wrote:
[Quoted Text] >Hey All,
>
>I currently have a routine that creates a table with a hyperlink reference
>to a network location (ACC2003). This hyperlink ends up being lengthy once
>I export this table to HTML. Is there a way in the export routine to give
>the hyperlinks a "friendly" name? This name would actually be data from
>another field.
>
>For instance:
>
>Field1:
>087-3334
>
>Field2:
>\\server\projects\year\client\part\revision\blahlahblah
>
>
>When I export I want the "087-3334" to hyperlink to Field 2's location.
>
>
>Thanks in advance....
>
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|