linking pictures

[peterbowles]

Say you have a register system and you want to link a photo of the student to there record, what is the best way to link the photo to the record?

Cheers

 

[daveUK]

Have a field in the table which stores the filepath location of the image.

 

[peterbowles]

could you explain a bit more, does any one have any examples

 

[daveUK]

Have a look at the following link

http://www.candace-tripp.com/_pages/access_downloads.asp

Specifically the 'Picture in Database' example.

 

[The_Doc_Man]

Concur with Dave

Just link (NOT EMBED) the image by having the picture file's fully qualified file spec (device, path, name, type) in your database for that person. Then, in the form's OnLoad event, load the picture file to the .picture property of an image control. Set the other properties so the image doesn't tile and so the alignment is centered. Have one more image floating around for the case where you don't have a picture file. Take a picture of a sign that says "No Photo Available." Use that for the default value of the .picture when you have a blank for the file name. Or make that value the default for the value in the table itself. Your call on exactly how.

 

[Oldsoftboss]

I must have posted a dozen times on this subject.....

http://www.access-programmers.co.uk/forums/showthread.php?t=62251