microsoft access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Microsoft Access

Microsoft Access

resolvedResolved · Low Priority · Version 2003

replyReply Tue 6 May 2008, 16:53Delegate Joanna said...

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.

For upcoming training course dates see: Pricing & availability

replyReply Tue 6 May 2008, 17:06 Edited on Tue 6 May 2008, 17:07Trainer Pete said...

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.

 

Please browse our web site to find out more about
ms+access+courses and other Microsoft training courses.

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard