Example Reports

Examples include printing crosstab queries, report menu dialog, etc.
Display:

Batch Printing
 4312 Downloads
 439.5 KB
 03-12-2016

This is an example based on the NorthWind example using the Invoice report.

I created a form to select the Invoices you want to print. There is a "Select All", "Unselect All",  "Print Invoices", and "Save as Snapshot files"  buttons.

To make it work I had to added one field to the "Orders" table. I added this field to the query form the Invoice report.

*** Updated  9/28/2010 ******

Added the ability to export the invoices to individual Snapshot (.snp) files.

Hope you find this useful.

 

*** The download includes a 97 and 2000 version. 

Will convert to Access 2007/2010

For 2007/2010 see: Batch Printing and Save As PDF

Batch Printing and Save As PDF
 5886 Downloads
 219.95 KB
 03-12-2016

This is an Acess 2007 format database.

This is an example based on the NorthWind example using the Invoice report.

I created a form to select the Invoices you want to print. There is a "Select All", "Unselect All",  "Print Invoices" , and "Save Invoices as separate PDFs" buttons.

To make it work I had to added one field to the "Orders" table. I added this field to the query form the Invoice report.

Hope you find this useful.

 

*** The download uses the built-in ability to create PDFs available in  Access 2007 and later.

Note: with Access 2007 you will need to be sure that you have downloaded and installed the  add-in for creatng PDFs..

Dynamic Report based on a Crosstab query
 14638 Downloads
 227.67 KB
 03-12-2016

Create a crosstab report with dynamic column headings. This example is based on this Microsoft KB article: How to create a dynamic crosstab report in Access 2002

You can use Microsoft Access to create dynamic reports that are based on parameter crosstab queries. You can also create reports to match a dynaset that is returned by such a query. Dynamic reports allow your customized reports to show only the most recently modified data. This gets rid of the need for fixed column headings and empty columns.

 The download includes databases in Microsoft Access 97 and Microsoft Access 2000.  formats  This will allow anyone with Access 97, Access 2000, Access 2002, Access 2003, and Access 2007 to use this example.

Picture in a Report
 3249 Downloads
 75.21 KB
 03-12-2016

By Candace Tripp (utter:angel) Access 2000 format

 

Demonstrates a method of displaying a picture/image file in a report without storing the image in a table.

Print Barcodes on an Access report
 3484 Downloads
 29.09 KB
 03-12-2016

This example is in Access 2000 format. It should work fine with Access 2000 and later.

 This example Access database shows how to print the Barcode 39 (also called 3 of 9) on an Access Report. 

**Note: The barcode font is stored in a table as a BLOB. It is installed and removed automatically for you.

 

Print Multiple Labels
 2588 Downloads
 19.33 KB
 03-12-2016

This example shows how to print a varying amount of multiple labels per record.

It also shows how to have 1 of X, 2 of X, etc. print for each item in a group.

Report Dialog Examples
 8078 Downloads
 85 KB
 03-12-2016

This example shows several different methods for selecting and running reports.