MS Access: Reports

Tutorials

• Report Basics (Understanding and creating reports) in Access 2007 | 2003
• VBA Basics (Understanding the VBA environment) in Access 2007 | 2003
• Debugging VBA Code (Understanding VBA's Debugging Environment) in Access 2007 | 2003

Navigation Pane (Access 2010 and 2007)

• Display reports in the Navigation Pane in Access 2007
• Display all objects (tables, queries, forms, reports, modules) in the Navigation Pane in Access 2013 | 2010 | 2007
• Display tables and related objects in the Navigation Pane in Access 2007

Formatting

• Border on a report page in Access 2003
• Dynamically size report object in Access 2003
• Hide report object if no value in Access 2003
• Suppress blank lines on a report in Access 2003
• Create a report title that repeats on every page in Access 2003
• Display a subtotal for each category within a report in Access 2003
• Left align a field in a report in Access 2003

Layout

• Create a 2 column report in Access 2007 | 2003
• Set up a report to print on legal size paper using VBA code in Access 2003

Conditional Formatting

• Change the formatting of a field in a report based on its value in Access 2003
• Change the formatting of a field in a report when the field contains a NULL value in Access 2003
• Conditionally format a field in Access 2003

Graphs

• Create a graph (ie: chart report) in Access 2003
• Fill in missing data on a graph in Access 2003

Checkbox

• Display a checkbox on a report in Access 2003

Page Breaks

• Force a page break based on the first letter of the LastName field in a report in Access 2003

Errors

• Trim function will not work in a report in Access 2003

Filter Results

• Filter report results using a date parameter in Access 2003
• Filter report results using the OpenReport VBA command in Access 2003
• Use the OpenReport VBA command to return only those records containing a keyword in Access 2003

Miscellaneous

• Determine if a report has no data in Access 2003
• Maximize report window but not affect other windows in Access 2003
• Email a report in Access 2003
• Report Example (Employee hours worked per day) in Access 2003
• Display parameter values in a report based on a parameter query in Access 2003
• Create lines at the end of a report so that handwritten entries can be added in Access 2003
• Using WeekdayName function in a report in Access 2003
• Counting the number of records with a blank field in Access 2003
• Set up a text box to display the difference between two dates in Access 2007 | 2003