Inserting Hyperlinks into a Table using an Append Query

  • Thread starter Thread starter jeff
  • Start date Start date
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
 
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
update hyperlink values but not displayed text 1
Schedule Auto run Query on append table 0
Append ODBC tables into Access Table 5
Add Table Name as Field in an Append Query 1
Can a query field display as datatype hyperlink? 1
Appending Records Using DMAX 4
AutoNumber Field Not Populating with Append Query 2

Back
Top