Adding a photo to my database?

[Scottik38]

Hi there, this is my first post, hopefully not too many more problems i will encounter whilst designing my database.

Anyway I am trying to add some fotos to each of my records, but not having as much luck as i would like. In the tables, i have made the field OLE object. When i try to add the foto (about 97kb) jpg format, all it does is add a picture of the jpg icon on my field. If i double click on the icon my foto will open, but i wish to have the foto showing in my record.

Anyone help me with any ideas? I am using access 2003

 

[stevepain]

I stand to be corrected by mroe experienced users - but I too have had problems adding jpeg files - however, if you can convert to a bitmap you can use bmp files instead - might be a bit laborious to change a large number of files though.

I am approaching a potentially similar situation - so any further advice/commetn would be useful to me too, but at present I am resigned to having to make all files bmp's to add them.

 

[The_Doc_Man]

1. The forum's SEARCH function works fine. On the forum's menu bar, Search is 3rd from the right. Try topics "Image" and "Picture" to start with.

2. There is a form control called an IMAGE control. Rather than use OLE, I highly recommend that you just build a static image control. Add the name of the picture file as a field in your DB table for that form. Then, in your form's "OnCurrent" event, write a little bit of code to move the name of the picture file to the image control's .PICTURE property. You might wish to play with the other properties. I do not recommend setting the TILE option or the one that allows asymmetric "stretch to fit" type ZOOM. You want a proportional stretch, perhaps, but not the asymmetric one. I also do not recommend the IMAGE control option to EMBED the picture. Just link to it.

3. If you have trouble with your image format, don't give up on it right away. Re-install Access. When you do, you can change the options that are loaded with it. Go into the conversion support section that includes all sorts of file formats. Find the one that corresponds to your favorite photo file and make it permanently resident on your hard drive. Then try the image again. Access needs the display module for whatever you want to display and this is how you get it. (If it exists in the kit.)