How do I insert a photo in a database record for that record only

[Chris]

I want to put a different picture into an individual database record in
Access 2007. Can anyone tell me in simple steps how I can do it. Thanks

 

[Dale Fye]

My recommendation is "Don't". Pictures rapidly consume the limited database
storage available to an Access user.

Instead of actually storing the picture in your database, store the picture
in a secure location on your computer or network. Then store a pointer
(filename) to that picture in a text field in your database.

With this information, you can either hyperlink to the picture, or set the
Picture property of an image control to the filename.

HTH
Dale

 

[Chris]

Thanks Dale. I will do that. Can you help me in inserting the photo? I can
get it to show on all records but not a single record. When I get close on a
single record, I get grey diagonal lines acrosss the photo. Being a bit of a
novice I need step by step help. I also read in a discussion that photo size
matters.

 

[Neil]

Hi Chris,

Check out:

http://www.nwarwick.co.uk/AccessPictures.html

for a tutorial to do exactly what you want.

It's written for Access 2003, but there should be no reason why it won't
work in 2007.

HTH

Neil
www.narwick.co.uk