Including images in a report (or form) for each record by linkin

Resolved · Urgent Priority · Version 2002/XP

Sun 8 Mar 2009, 19:17 Delegate Jason said...

Jason has attended:
Access Advanced course
Access VBA course

Including images in a report (or form) for each record by linkin

Hi,

I would like to include images that are saved on my C: Drive within the forms and reports of my database. The images need to be linked so the database does not balloon in size.

So I need to add a bound object frame to a form that has the control source as the "image" field in the table. From the table I right click in the "image" field and insert an image by selecting the "create from File" option, browsing to the image and clicking the "link" option box. I DO NOT select the "display as icon" option.

But when I view my form it displays the icon and file name but not the image. If I double click on the icon it open the image.

Any ideas where I am going wrong?

MR VERY Confused

Mon 9 Mar 2009, 16:05 Trainer Rajeev said...

RE: Including images in a report (or form) for each record by li

Dear Jason

Thank you for attending Access Advanced and VBA courses!! I hope you enjoyed the courses and benefited from them.

Normally Access is very fussy when it comes to graphic files.

It would be worth investigating the format of the picture files i.e. gif, jpg or bmp.

Please refer to the following link to get insight of how Access deal with graphic files.

It mentions various ways of accessing pictures in MS Access such as OLE, bound, unbound etc...

http://office.microsoft.com/en-us/access/HA011472041033.aspx #DispImg

This is another link that specifically talks about using Jpeg or gif files in MS Access.

http://www.ammara.com/articles/access-jpg.html

Please let me know if these links are useful to you and if they help you in resolving your specific query!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips