98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Including images in a report (or form) for each record by linkin
Including images in a report (or form) for each record by linkin
Resolved · Urgent Priority · Version 2002/XP
Sun 8 Mar 2009, 19:17Delegate 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:05Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |
