Displaying pictures in a Form

[Guest]

Hi,

Purpose: Form created which displays details for Staff. Unique key is a
number eg: Staff number. I have a picture of each staff member on a CD. These
Pictures are tiff files which have the same unique number as the staff
number. I dont have enough disk space to store on the local drive or database.

Requirement: I would like when the form is opened for a staff member for the
staff picture to be displayed. I have tried using unbound objects but the
same picture comes up for each staff member. Is their a way that I can set it
up so that I can see the individual picture for each staff member.

Any help at all would be appreciated.

 

[Jeff C]

Hi,

Purpose: Form created which displays details for Staff. Unique key is a
number eg: Staff number. I have a picture of each staff member on a CD. These
Pictures are tiff files which have the same unique number as the staff
number. I dont have enough disk space to store on the local drive or database.

Requirement: I would like when the form is opened for a staff member for the
staff picture to be displayed. I have tried using unbound objects but the
same picture comes up for each staff member. Is their a way that I can set it
up so that I can see the individual picture for each staff member.

Any help at all would be appreciated.

You need an unbound ImageFrameontrol on your form, which will hold the
photo.

In the ONCurrent event use the following:
Me![ImageFrame].Picture = "D:\StaffPhotos\" & Me![StaffNumber]& ".tiff"

This presumes that all staff photos are in the same folder on the CD.

Hope this helps,

Jeff C.

 

[Guest]

Hi Jeff

I have created this as per your instructions the message that I get is

Microsoft access cant find the macro Me!imageFrame

What do I need to do here??

Thanks



--
Phil

Hi,

Purpose: Form created which displays details for Staff. Unique key is a
number eg: Staff number. I have a picture of each staff member on a CD. These
Pictures are tiff files which have the same unique number as the staff
number. I dont have enough disk space to store on the local drive or database.

Requirement: I would like when the form is opened for a staff member for the
staff picture to be displayed. I have tried using unbound objects but the
same picture comes up for each staff member. Is their a way that I can set it
up so that I can see the individual picture for each staff member.

Any help at all would be appreciated.

You need an unbound ImageFrameontrol on your form, which will hold the
photo.

In the ONCurrent event use the following:
Me![ImageFrame].Picture = "D:\StaffPhotos\" & Me![StaffNumber]& ".tiff"

This presumes that all staff photos are in the same folder on the CD.

Hope this helps,

Jeff C.