Displaying different image per record

S

SteveWalker

Hi,

I've got a form which displays data for the selected student, and I've got a
load of jpg images of students. I need to display the image of the selected
student on the form. I'm probably missing something very basic here, but
what's the best way to go about it? I really just need to know which object
I'd be best off using to display the image - I've been trying out various
different objects and haven't had any luck.

Thanks a lot,
Steve Walker
 
R

Roger Carlson

Are you storing the images in the database itself? If so, I'd advise
against it. It will bloat your database very quickly. The usual solution
is to leave the pictures in the file system as graphic files (bitmap, jpeg,
etc) and just store the file location in the database. Then you can load
the picture programmatically in an image control.

On my website (www.rogersaccesslibrary.com), there is a small Access sample
database called "Picture.mdb" which illustrates how to do this.
--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top