update hyperlink addresses on mass

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have table with a hyperlink field in it. Is there a way of updating the
address of the hyperlinks on mass.

Thanks
Matt
 
Hi,
sure...you can run an update query on the values like you can for any other
data type.
A hyperlink can consist of three parts which are seperated by pound '#'
symbols. The first part is the display text, the second the link itself, and
the third could be a reference within the link destination.
So if you wanted to replace ALL hyperlinks with the same one then for
example you could use this in the update to area of your update query:

Left([HyperLinkField],Instr([HyperLinkField],"#")+1) & http://www.msn.com

If you run the update query you would replace ALL links with msn.com. They
display text would stay the same.
HTH
Good luck
 
You must log in or register to reply here.

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

Open specific hyperlink (accept) automatically in email with outlook 0
Will not auto open .jpg 1
update hyperlink values but not displayed text 1
making hyperlink in query 1
create hyperlink & append table 1
Can a query field display as datatype hyperlink? 1
Word hyperlink not showing once merged 0
How do I update address of hyperlink field in Access via query? 1

Back
Top