add pictures to a table line

[Paul \(OMAC HX\)]

Hi all,

I am enquiring is it possible to add a picture to each line in a table.Some
may be blank and some may have pictures on it.
The table is run as a search form and that is up and running though i am
trying to add pictures of people to go with there
information

I am just wondering is this possible and if so how.
and if it is possible Where does the picture go that are saved.

Thank you for any help

Paul

(e-mail address removed)

 

[Ken Snell \(MVP\)]

If you're using ACCESS 2003 or an earlier version, it's best to not store
pictures directly in a table's record -- this is because your ACCESS file
will bloat greatly. Instead, store the path and file name of the picture for
that record; then use programming in the form's Current event to set the
Picture property of an Image control to the path/filename from that field.

If you're using ACCESS 2007, it handles the storage of pictures very well,
so you can store the picture in the record.

 

[HeatherJ]

Maybe you can help me too. I have a field for a link to pictures stored on my
website. Is it possible to split the URL? I'm think of having a seperate
table with the http://www...... part of the path in it then just have the
file name in the main table. My concern is if I move the pictures to a
different directory or subdirectory I don't want to have to go in a change
every single record in my database.

Thanks in advance
Heather

 

[Ken Snell \(MVP\)]

Sure, you could store part of the path in one field and the rest of the
path/filename in another field. These fields could even be in different
tables. You would concatenate the two fields' data into a single string,
then use that string.