When you right click the report, Show
Attachments, you can choose the mode in which you want it to be
displayed: Open, Layout, Design, and Print Preview as shown in Figure 19.
Design view of the report
In the design view you can see how the various controls are
placed. In this view you will be able to access the properties window of
all the sections and controls, make changes, or attach code or macros to events
etc. In fact, the default design view of the report occupies such a large area,
that it was drastically altered by making all objects occupy a smaller area than
can be shown in a single, smaller screen as shown in Figure 20. Each attachment
carries with it several pieces of attachment information.
Layout view of the report
For each attachment in a row, a layout file block section is
generated. For the Employee, 'Jay' three such blocks, one each corresponding to
the attachment will be present. If you are using the report for the first time
you may get somewhat confused. A partial picture of the report in layout is
shown in Figure 21. There are 3 such items for the employee, 'Jay' and only one
for employee, 'Tom'. Figure 21 only shows a part of the first two blocks for
the attachments for employee, 'Jay'
Report Print Preview
This will vary depending on how the report is configured in
the design. For attachments, it would just show icons for the attachments if
they exist. In the report considered in this tutorial, since the design was drastically
altered, objects get displaced in the print preview
as shown in Figure 22. You may notice that the attachment related icons are
drastically displaced and shown on top of other fields.
When you pick Open in the
drop-down menu for the report (Figure 19), the window shown in Figure 23 will
be displayed: It is similar to the layout.
When you click on the EmpResumePhoto control’s box as shown
in Figure 24, you will notice a small navigational control for the attachments
pop up as a floating window. Here you can choose the desired file from the
three for the employee, 'Jay'.
If you click on the attachment icon (paper clip), you will
open up the attachment window as shown in Figure 25.
Here you may select the file you want to view and click on
the View button. This pops up an executable program
which is supposed to work with this type of file extension. As shown in Figure
26, for the mp4 music file, the Y!Music Jukebox 2.0 application opens. This Access
2007 program is running on a Windows XP Multi Media OS.
For the next item on the attachment a different program will
execute the item as shown in Figure 27 for the picture file. Microsoft Word
will start when you click on the third attachment (not shown).