Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access

ResolvedVersion 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.

Edited on Tue 6 May 2008, 17:07

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.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.