Pictures in forms

[Blakey300]

I am using Access 2007 and am developing a membership database for which i
would like a picture of the member to be visable on the members form.

I want to link to the pictures as there will be over 200 members minimum and
I do not want to save them in the actual DB due to save.

My questions are as follows

1) In my members table should i use attachment or OLE Object?

2) What is the best file format to use for the pictures?

3) How do I get the picture to automatically show when the form is open, as
I currently get an icon that i have to double click, then the pic opens in
another program (ie ms photo manager)

4) Which control type should I use on the form (Bound, unbound or image)

I am new to access 2007 (used previous versions but as you can probably tell
i am no expert) and the more threds i look at on here and the more i try to
disect northwind the more confused i get.

Please help

Regards

Dave

 

[ruralguy via AccessMonster.com]

Larry's sample db's should help here.
http://accdevel.tripod.com/imaging.htm

 

[Blakey300]

thanks for your reply but found just using the attachment property worked a
treat

 

[ruralguy via AccessMonster.com]

Great! That is why MS put it in ac2007. Thanks for posting back with your
success.

thanks for your reply but found just using the attachment property worked a
treat

Larry's sample db's should help here.
http://accdevel.tripod.com/imaging.htm

[quoted text clipped - 26 lines]