Microsoft KB Archive/98801

From BetaArchive Wiki
Knowledge Base


ACC: How to Print a Single Record from a Form in a Report

Article ID: 98801

Article Last Modified on 1/18/2007



APPLIES TO

  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition



This article was previously published under Q98801

Moderate: Requires basic macro, coding, and interoperability skills.


SUMMARY

This article shows you how to select a single record on a form and to print it in a report.

MORE INFORMATION

The following procedure prints only the record that you select from the Customers form in the sample database Northwind.mdb (or Nwind.mdb in earlier versions).

  1. Create a report based on the Customers table and name it rptPrintRecord.
  2. Create the following macro and save it as mcrPrintRecord:

    NOTE: The expression in the OpenReport event is refering to the CustomerID field of the customer's form.

    In Microsoft Access 97:

             Macro Name       Action
             -----------------------------
             mcrPrintRecord   RunCommand
                              OpenReport
    
             mcrPrintRecord Actions
             --------------------------------------------------------------
             RunCommand
                Command: Save Record
    
             OpenReport
                Report Name: rptPrintRecord
                View: Print Preview
                Where Condition: [CustomerID]=Forms![Customers]![CustomerID]
                            

    In Microsoft Access 7.0:

             Macro Name       Action
             -----------------------------
             mcrPrintRecord   DoMenuItem
                              OpenReport
    
             mcrPrintRecord Actions
             --------------------------------------------------------------
             DoMenuItem
                Menu Bar: Form
                Menu Name: Records
                Command: Save Record
    
             OpenReport
                Report Name: rptPrintRecord
                View: Print Preview
                Where Condition: [CustomerID]=Forms![Customers]![CustomerID]
                            

    In Microsoft Access 1.x and 2.0:

             Macro Name       Action
             ---------------------------
             mcrPrintRecord   DoMenuItem
                              OpenReport
    
             mcrPrintRecord Actions
             --------------------------------------------------------------
             DoMenuItem
                Menu Bar: Form
                Menu Name: File
                Command: Save Record
    
             OpenReport
                Report Name: rptPrintRecord
                View: Print Preview
                Where Condition: [CustomerID]=Forms![Customers]![CustomerID]
                        
  3. Open the Customers form in Design view. Add a command button to the form and set the following command button properties:

    In Microsoft Access 2.0, 7.0, and 97:

             Name: cmdPrintRecord
             Caption: Print Record
             OnClick: mcrPrintRecord
                            

    In Microsoft Access 1.x:

             ControlName: cmdPrintRecord
             Caption: Print Record
             OnPush: mcrPrintRecord
                        
  4. Open the form in Form view, and then click the Print Record button. Note that the report contains only the current record from the Customer form.



Additional query words: one

Keywords: kbfaq kbhowto KB98801