Is there to paste a group of addresses into a group of hyperlink Access Cells?

[rebfein]

I have a 10K+ record database table that I need to change in the following way:

My boss wants to add a picture of each part listed in the database (Lord help me). Taking the pictures was fairly easy.

I added a hyperlink field to the table. I added a folder to the database entitled 'Screen Shots,' where the pictures will be stored.



I have, however, discovered that the link does not work when I copy groups (100 at a time) into the fields (1 picture link per each record cell).

How can I do this without having to individually copy each address into each cell?

Many thanks,

[Micron]

You didn't say what the relationship is between a picture id/file name to a db record. If there is one, an update query I would think. If not, I don't know. Hopefully when you say "cell" you mean field, as I see no mention of a spreadsheet here. Tables don't have cells, so I'm not sure of the connotation.

Further, I would not use a hyperlink field for this; rather a text field with the complete path and an image control that references that path, assuming we're talking about viewing the image on a form. I think you will find the hyperlink field will only add headaches.

[June7]

Agreed, if you want to view images in form or report, a hyperlink field will add complication. Can't really paste a value into hyperlink field anyway. Where were you copying these paths from?

As Micron said, use a text field that saves file path. Then if you want to use image in form or report or open the image in a viewer app, that field can be used. Will require some code to open in viewer app.

If the image file name includes the part identifier, code can loop through images folder and save the path to appropriate record.