add pictures to a table line

  • Thread starter Thread starter Paul \(OMAC HX\)
  • Start date Start date
P

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)
 
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.
 
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
 
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.
 
Back
Top