Photo on record

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

Hi,
I would like to enter somebody's name, get the correct record and the
corresponding photo.
Getting the correct record isn't really a problem but getting the
corresponding picture is...
I studied the help file but it's all too confusing for me.
Could somebody please explain?
Thanks
JP
 
Hi,


Microsoft Northwind Form "Employees" does it.



Hoping it may help,
Vanderghast, Access MVP
 
Jean-Paul,

You need to store the photos in their own folder, preferably in .bmp format.

In your people table you need a field that contains the path to the photo of the
person in the record.

On your form you need a hidden text box that is bound to the field in the table
that contains the path to the photo.

On your form you need an image control.

In the form's OnCurrent event you set the Picture property of the image control
equal to the hidden textbox, ie:
Me!NameOfImageControl.Picture = Me!NameOfHiddenTextbox
 
Back
Top