Hyperlink field too short...is there another way

[MickM]

Hi All,

I need to include a hyperlink field in my table but the address string is too long and I cannot seem to get it to work!

Is there another way to add file links to a table?

Cheers

 

[ajetrumpet]

Hi All,

I need to include a hyperlink field in my table but the address string is too long and I cannot seem to get it to work!

Is there another way to add file links to a table?

Cheers

i would probably put the entire string in a memo field and then make it look like a hyperlink in your forms and reports along with a little code.

 

[MickM]

Thanks ajetrumpet,

But I am also need to export this to a spreadsheet.

FYI, here is an example string

"G:\AWD Project\98_Data_Packs_staging\02_BLOCK_107\DATA PACK RE-ISSUE 090805\BLOCK DRAWINGS\1075020020N Rev A INTERNAL PIPING ARRANGEMENT BLOCK 107\2009000019#Rev0001_BUILDING DRAWINGS\FAB1075002#Rev0001\546cpw004.tif"

Cheers

 

[ajetrumpet]

do what I said initally. put them in memo fields. then when the string problem comes about on the export to excel, use my CODE in the repository to convert them back to links automatically:

Convert Strings to Hyperlinks

if you're worried about having the actual links in the tables themselves, you're outta luck. you'll have to use the workaround i mentioned before. sorry.

 

[LPurvis]

Just to address the concept of
"i would probably put the entire string in a memo field "
Hyperlinks are Memo fields - just with an additional attribute set which causes Access to treat them differently.
Consequently there should be no problem with a long string.

However you say that you "cannot seem to get it to work".
That's less than descriptive of the actual problem.
Is the string correctly assigned, however it fails to launch? If so - saying what?
All important details.

However, looking at your example string, you'll notice it (somewhat unusually for a well named folder structure) contains a octothorpe (#).
These are used as delimiters in hyperlinks between the display text and the URL/UNC actual path. Consequently you're probably just confusing the expression and Access is attempting to launch a file which it thinks is described by the section between the octothorpes.

Consequently (and somewhat ironically) you will be best off implementing the non-hyperlink method as suggested.
(FWIW I personally dislike hyperlinks functionality-wise, though the appearance can be helpfully intuitive for users - that can be achieved by other display means).

Cheers.

 

[ajetrumpet]

thanks for the information leigh. good stuff, which i didn't know either.

 

[MickM]

Thanks Leigh, worked brilliantly. I have removed the '#' from the directories.

Cheers
Michael

 

[LPurvis]

No worries guys.