Adding a bitmap photo to table/report

[ianclegg]

Hi

Has any done the above, I have read many help forums but cannot figure it out.

I am wanting to store a bitmap photo in an access table and then want to include it in a report.

Thanks in anticipation

Ian Clegg

 

[GinaWhipp]

You really don't want to store pictures in the database, it will cause bloating which will push your database to it's max size (2 gig) very quickly. Try this link which has MANY samples of how to insert/display images in forms and reports.
http://www.granite.ab.ca/access/imagehandling.htm

 

[Geotch]

If you do want to add a picture to a table, you must use the .bmp file type. If you haven't figured it out, I can upload a sample for you.

 

[ianclegg]

Thanks for the help and advice, II really only want to add the photograph to my report.

My tests with adding a bitmap to a database file have all failed. I would really appreciate an example. I will checkout all the links as suggested.

Ian

 

[Geotch]

Here is an example database. You must save the picture as the 24 bit bitmap. If you don't it will turn out like employees 2 and 3 in the attached database.

 

[vbaInet]

Here is an example database. You must save the picture as the 24 bit bitmap. If you don't it will turn out like employees 2 and 3 in the attached database.

... and feel free to use the pictures as you see fit

Anyway, ianclegg you really don't want to save pictures in your db. If it's a one off image then it's fine however if you want to display multiple pictures then you want to follow what is explained in the link GinaWhipp sent. It helps to keep your db size down and consistent.