Hyperlink Hell

[RedHeadedMonster via AccessMonster.com]

I have a table that holds internal links to documents on local server. I
wanted to fill in default location. So I went into the table design and
filled in what the default locations are for certain types, i.e. Document
default working folder is :\\servername\shared\projectname\workingfolders\.
There are more folders under this that are more specific to types of
documents. But wanted to have this default available until the detailed
folder was entered.

When you open the table it shows you the default and it appears clickable.
Problem is, evidently Access only fills in the TEXT TO DISPLAY as the default
and leaves the address empty. Anyone know of a way to fix this?

Thanks!

RHM

 

[FredFred]

I'm no expert but from what I see, put the display, then a # sign then the
link.

If your display IS the link, I think the one in youor example would be
:\\servername\shared\projectname\workingfolders\.#
:\\servername\shared\projectname\workingfolders\.

 

[Keith Wilby]

I have a table that holds internal links to documents on local server. I
wanted to fill in default location. So I went into the table design and
filled in what the default locations are for certain types, i.e. Document
default working folder is
:\\servername\shared\projectname\workingfolders\.
There are more folders under this that are more specific to types of
documents. But wanted to have this default available until the detailed
folder was entered.

When you open the table it shows you the default and it appears clickable.
Problem is, evidently Access only fills in the TEXT TO DISPLAY as the
default
and leaves the address empty. Anyone know of a way to fix this?

Check out the HyperlinkPart method int the help, it might be what you need.

Keith.
www.keithwilby.com

 

[RedHeadedMonster via AccessMonster.com]

Thanks Fred & Keith! Will try the # trick and will check out the
HyperlinkPart.

Have a nice day!

RHM