picture in database

  • Thread starter Thread starter Jaycee
  • Start date Start date
J

Jaycee

I'm new to access but I've managed to convert a contact template database
into an employee tracking database file. My question is that I want to place
a picture of each individual employee on their own database record. I tried
doing this but everything that I go to the next record, I get the same
picture displayed there. I want to be able to have a photo of each employee
in his/her own record in the database. Can anyone help? thank you.
 
you don't mention which version of access you are working with so I'm
assuming 2003 or earlier.

Take a look at the following example. They all demonstarte how this is
accomplished.

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb
http://www.rogersaccesslibrary.com/download3.asp?SampleName=PicturesLoad.mdb

The idea is not to store images in the database itself as this will lead to
tremendous database bloating. Instead, only save the path (text) to the
image and load it dynamically as required.
 
The links are good but what I need to do is place a picture on each record of
the individual whose info is on it so when I go from one record to the other,
it shows that particular person's picture. I orginally tried with one pic to
see if it worked but I kept getting the same pic on every record. I dont want
to open another form with the person's picture as these example show. I want
to open each record with each person's pic on it. As for what I did, I
inserted the pic itself onto the particular individual's record which was,
obviously now, wrong.
 
By the way, yes, I am using Access 2003

Daniel Pineault said:
you don't mention which version of access you are working with so I'm
assuming 2003 or earlier.

Take a look at the following example. They all demonstarte how this is
accomplished.

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb
http://www.rogersaccesslibrary.com/download3.asp?SampleName=PicturesLoad.mdb

The idea is not to store images in the database itself as this will lead to
tremendous database bloating. Instead, only save the path (text) to the
image and load it dynamically as required.
Click to expand...
 
Same principle but u need to code the oncurrent event to dynamically change
the image whenever the record is changed.

The example from Rager's Library Picture2k.zip shows exactly the method to
implement.
--
Hope this helps,

Daniel Pineault
 
I'm looking at picture2k now. thanks for the help. Will post here again to
let you know how things worked out.

Jaycee
 
Back
Top