Adding Image Files Automation

[Elmobram22]

Hi,

I have a form for adding new records. They are for people and I add in a bmp image of them. I want to create an automation. Where you press a button to add a photo. Find a jpeg you want. Then it is resized, converted to bmp and saved in the database. Is this easy enough to achieve? (size 256x188px)

Cheers,

Paul

 

[Simon_MT]

Why not leave the images as jpegs.

I have over 20,000 images and these render automatically onto the form or report because the image file name is the Stock Reference.

Simon

 

[BeeJayEff]

As Simon says, leave it as a jpg. But do you really want to keep the images in the database ? My db references images in a separate folder where they can easily be manipulated, resized, replaced, etc..

 

[Elmobram22]

Why not leave the images as jpegs.

I have over 20,000 images and these render automatically onto the form or report because the image file name is the Stock Reference.

Simon

How do you render them automatically? And thanks for the reply

 

[Simon_MT]

In a Query you need the full name of jpg file shall we call it the ImageFile.

Two Parts

1) DirectoryPath eg:

C:\Images\

2) Employee Image

ImageFile: DirectoryPath & EmployeeID & ".jpg"

Create an Image with a Control Source =[ImageFile]

Result

C:\Images\1.jpg

Simon