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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 28 Dec 2007 00:34 GMT

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

Reply to this Message

Dale Fye - 28 Dec 2007 13:59 GMT

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

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

> 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

Reply to this Message

Chris - 28 Dec 2007 22:40 GMT

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.

> My recommendation is "Don't". Pictures rapidly consume the limited database
> storage available to an Access user.
[quoted text clipped - 11 lines]
> > 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

Reply to this Message

Neil - 30 Dec 2007 20:17 GMT

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

> 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
[quoted text clipped - 17 lines]
> > > 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

Reply to this Message