Hi

I constructing an Access database for a charity and want to have total control over storing an image for each record. The way I want it to work is that the user selects an add image button which opens a browser. The user browses and selects the image the code then copies that image, resizes it changes the res, and stores this new image in a specific place. The image control on the record form will then reference this new resized image. I have a fair bit of VBA experience so have no problem opening a browser dialogue, etc but don't have a clue how to to resize the image.

The reason I need to do this is that the user will not have much graphic manipulation experience and I need to keep control of the size (as in bits)and location of the images used.

This is really doing my head in so any help will be very much appreciate.

Cheers.

If you are going to be handling a lot of images it is not a good idea to store them within MS Access, it would be better if you save them as separate files and the database provides a link to the file, displaying the pictures when necessary.

Thanks dude but I still need to keep control over the size and res of the images so any ideas?

If you want to keep control within Access, you're probably going to need to get a dedicated ActiveX control which will let you load and manipulate the image. There are a lot of them available, but none of them that I use are inexpensive. And Uncle Gizmo is absolutely correct. I do a lot with imaging and there is tremendous overhead in storing images in an Access or SQL table.

Thanks, I will take Uncle Gizmos advice by linking to the image rather than embeding it. I don;t need the user to see and manipulate the image though, so will that make a difference? I will have a set size and res and need some VB code to resize it to these set criteria.