Inserting Hyperlinks into a Table using an Append Query

J

jeff

hi gurus!

I have an Append query which is inerting records into a table with a
Hyperlink Data column. The query formats the path eg "PDF/fielname.pdf" and
appends it to the field.

However when I open the table and try to click on the hyperlink field the
link doesnt work. I rightclick and select edit hyperlink and notice that the
text to display is set but not the hyperlink.

Can anyone help me out here?

cheers
Jeff
 
A

Allen Browne

The hyperlink consists of the display text, address, and a possible
subaddress, separated by #.

To assign the value to the field, your append query needs to include these #
e.g.:
PDF/fielname.pdf#PDF/fielname.pdf#

More info:
http://allenbrowne.com/casu-09.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create hyperlink & append table 1
Add Table Name as Field in an Append Query 1
update hyperlink values but not displayed text 1
Append query - Append to table with Autonumber field 2
Append only new records to a table 2
Append Query 2
Append ODBC tables into Access Table 5
Hyperlinks in a query (Access 2003) 1

Top