still problems with hyperlinks

[Guest]

I reposted this because I really need help. Does anyone know how to make
15000 hyperlinks functional in Access 2000?

Here is my original question:
And then answer:

Access 2000 has a "Hyperlink"data type. What about designing your table to
use the Hyperlink data type for that column and then using the Import Wizard
to populate that column from your .xls file?

Then still my problem:
Hi Mike, I tried to do what you said but the link still will not work
because the hyperlink column will not reconize the importet text and/or link
as the actual link. I can select each record and edit manually through the
hyperlink editing option, but I have 15000 records that I need to change.
And maybe later I would have to update them too.


Thanks for any help, Carolyn

 

[Roger Carlson]

When you programmatically set a value to a hyperlink field, you need to add
pound signs (#) around it to make it active. (They will not be visible).
If you can't do it in you import, you can use an Update query to add them.
Something like this:

UPDATE tblTest SET tblTest.hyperdocs = "#" & [hyperdocs] & "#";

where "tblTest" is the table and "hyperdocs" is the field.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Hi,

This worked for me:
UPDATE table_name SET table_name.[column_name] = "#" & "http://" &
[column_name] & "#";

/Eva


"CarolynJ" skrev: