Problem populating a hyperlink field

R

R. Wilson

Access 2002. I have a table with a hyperlink field that I want to populate
with drawing image files related to the records (inventory parts). Our
drawing numbers coincide with our part numbers. So I wrote an update query
to trim and merge the part numbers with the network path and file extension.
I have a couple thousand images to link so doing this manually is not an
option. I run the query and it populates the field correctly, but there is
no hyperlink actually established. If I delete the content of the field and
hand type it back in the hyperlink is established. HELP! I can't do these
by hand plus I have new drawings created daily. Can anybody tell me what I
am doing wrong or what I can do?

Thanks, Rob Wilson
 

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

Problem with populating a hyperlink field 1
Hyperlink field that does not link to the file 3
Hyperlinks in mail merge---not merged fields! 1
Auto-Populate Form Field 1
Conditional Expression on automatically populated field 1
change all hyperlink values in table 3
calculating a remainder field 0
How to Populate Hyperlink Field from ComboBox? 0

Top