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.