Updating a Hyperlink in a Table

G

Glenn Suggs

I have an Access table that has a field defined as a Hyperlink that points to
a file on the server. But when I run an update query to update the field
with the path to the file, the Hyperlink does not work. When I right click
the field (after running the update) and select Hyperlink, and then Edit
Hyperlink, the Text to be Displayed is filled in with the path but not the
Address field itself. It only works when I manually type in the Address as i
can't get the query to update it. Is there some VBA code I can use through
DAO to update the Address part of the Hyperlink as well.
Thanks in advance.
 
G

Glenn Suggs

Thanks Alex,
That did work but I had to but a # sign at the end of the second part, too.
 

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

deleting a external file from access 2007 2
HyperLink String (edited question) 2
Create hyperlink by using VBA in conjuntion with API0001 Dialog Bo 8
Data Defnition Query 1
HYPERLINK QUESTION 2
Will not auto open .jpg 1
Hyperlink to a folder 1
Access Extract Hyperlink URL as String - Access 2010 0

Top