Get images to unbound obj frame from a directory

[mybers]

Hello

I know using OLE object in tables makes the system slower esp as the files gets bigger.

I have a 201 files with pics Id like to show/get the pictures from a directory (i.e. d:\HRD\employees\)

I can reference the images with their employeeID no as its filenames. (e.q. emp01.jpg)

Can the unbound obj frame search the images AUTOMATICALLY from the Dir reference to their employee id number?
at the same time STRETCHED?

Im not a hard coder though but any code will do...

MUCHAS GRACIAS

 

[PHV]

Do a keyword search in this forum for picture

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

How are ya mybers . . . . .

[purple]Don't forget to backup the DB before you make any changes[/purple].

Add a field to your employee's table to hold the path & filename of the picture. Add a few Paths in Table view.

In your form add an Image Object from the toolbar. Initially you have to select any graphic. Delete the Path & Filename from the Picture Property.

Then in your forms [blue]On Current[/blue] event add the following line:

[purple]Me!YourImageCtlName.Picture = Me!YourPathFieldName[/purple]

Your pictures will follow right along as you change records . . .

Remember Our Veterans! Remember Sept 11th!