98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Microsoft Access
Microsoft Access
Resolved · Low Priority · Version 2003
Joanna has attended:
Access Intermediate course
Microsoft Access
How do I link a photo to a specific record so that an individuals phtot is printed along with their report. Can I link it to an individual's ID (the primary key?) as I am sometimes unsure what an individual looks like so need it to be accurate. Thanks.
RE: Microsoft Access
Hi Joanna, welcome to the forum, thanks for the post, in answer to your question:
There may be times when you want to add an unbound picture (such as your company logo or product image) to your Microsoft Access form. It's easy to add pictures to forms with the Image control.
However, an embedded form object can take up a huge amount of space in your database. Think of a Bitmap file for each record.....
To save space, try linking the image to the form, rather than embedding it. Here's how to link a picture to your form:
Open the form in design mode.
Click the Image button in the toolbox.
Click and drag to insert the image on the form.
Navigate to the image file containing the picture you want to link to, select it, and click the OK button.
Right-click the image and select Properties.
Click the Picture Type drop-down arrow and select Linked.
Note that the image file must be available in your folder when the form is running; otherwise, the image will not be displayed.
In a case like this you do not need to attach to the primary key or any other field in the database, again saving on space and computing power.
I hope that has helped, best regards Pete.
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:Zoom feature for queriesIf youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field |