Creating an Access report for jpeg photos with a Photo Control

You can create an Access report with your jpeg photos, by adding an third-party Active X control such as DBPix from Ammara Software.  This control works with Pendragon Forms images without the need for code. 

Although other controls may be available, we used this one to create sample reports.  The control can also be used to create other Access objects. 

To use the control to create an Access Report with jpeg photos:

First, install the control as directed.  Note: This is not a Custom Control.  This control is installed on the desktop PC and does not require handheld installation.

Next, we will create an Access report that contains the data from the Date, Location and Photo fields in our form.

In order to generate the report, we need to know the name of the Access data table for our form.  This information is available on the Pendragon Forms Manager Form Properties screen. 

In the Pendragon Forms Manager, highlight the name of the form, and click the Properties button. 

Note the Table Name for this form and then close the Properties window.

Bring the Access Database Menu forward and select Reports form the list of Objects. 

(If it is not visible, select Forms32K: Database... from the Window menu at the top of the screen.)

Double click Create report in Design view.

You will see a blank report design.  From the Data tab in the Report window, for Record Source, select the name of the Data Table for your form.

A window that contains a list of fields in your Data Table will appear.   Drag and drop the fields from the list onto the Report design area (in this case, the Date1 and Location fields).

Do not place the Custom Control field onto the report (no data is stored in this field).  Do not place the Photo (or other field where images are stored) onto the report design.  Photos will be added to the report via the control in the next step.

On the Tools menu, select ActiveX Controls. From the Insert ActiveX Control box, select DBPix 2.0 Control and click OK.

The DBPix Control adds a box to your report design.  Resize the box to fit your pictures and your report design. 

On the Data tab, for Control Source, select the name of the field in which your images are stored (in this case, Photo).

Click the View button to see the report. 

You can modify the design of the report, print or save. 

You can resize and format fields and layout to enhance the appearance of your report design.

Previous:

Introduction: Using a PDA camera for data collection

Creating a form for photo data collection

Taking pictures

Synchronization & data review

Creating an Access report (for bitmap images only)

© 2004 Pendragon Software Corporation.  All rights reserved. Copyright and trademark information.