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.

Sorry for being blond!!!

Please help

Regards

Dave

 

[Scott McDaniel]

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?

If you're not storing them in the database all you need is a Text field to store the PATH to that picture.

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

Access image control works with many different formats, but BMP or JPG seem to be the most universal.

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)

Use the Image control, and set the .Picture property of that control to the Path you've stored in the Form's Current
event:

Me.YourImageControl.Picture = Me.YourImageFilePath

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.

Sorry for being blond!!!

Please help

Regards

Dave

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[ירין ×זול××™]

hi