Using Microsoft Access

Access Reports - Tips and Tricks
Web LinksMiscrosoft access Reports - links to articles that show how to do some great stuff with Access Reports
Display # 
# Web Link Hits
1   Link   Access 2000 sample: report topics: database available for Download
The Access 2000 Sample: Report Topics database contains sample reports that demonstrate how to perform a variety of reporting tasks
2   Link   How to Print a Constant Number of Lines Per Group
This article describes how to create a constant number of lines per data group on a report. You can use this method to consistently print 15 lines per data group, regardless of the actual number of items within the group. Note that if the group contains more than 15 items, the function used by this method will not apply.
3   Link   How to Print a Group Footer at a Specific Location
This article describes how to print a report's Group Footer information at a specific place on the page. This can be useful when you are printing reports to preprinted forms. Although you cannot do this using the Group Footer's property settings, you can use any of the following three methods:

* Place the information in the report's page footer, which is always printed at a fixed location.
* Set the report properties for the footer section.
* Set the report properties for the detail section.
4   Link   How to Print Line Number for Each Record/Group on Report
This works for Access 2000 and later.

You can add a text box control that prints a sequential number for each record to the detail section of a report. You can reset this number so that a separate set of numbers is printed for each group of record
5   Link   How to Print a Single Record from a Form in a Report
This works with Axcess 2000 and later.

This article shows you how to select a single record on a form and to print it in a report.
6   Link   Leader Dots by Stephen Lebans
a database containing functions to allow a user to fill in the space between 2 controls with leading dots.
7   Link   Print Lines Class by Stephen Lebans
PrintLinesClass - Create Vertical lines, Borders and boxes with the addition of a simple to use Class to your project
8   Link   Programming Printer Settings in Microsoft Access 2002 and later
Summary: This article discusses how to change printer settings programmatically in Microsoft Access 2002 applications by using the new.

Note: The new printer object was first available in Access 2002 and is available in all later versions.
9   Link   Report to PDF tool by Stephen Lebans
A2000ReportToPDF is an Access 2000 database containing a function to convert Reports and Snapshot files to PDF documents. No PDF Printer driver is required. This archive contains new versions of the StrStorage and DynaPDF libraries. Please make sure you delete your old versions, especially if you copied them into your Windows\System32 folder.
10   Link   Reset page numbers for each group in a report
11   Link   Use a multi-select list box to filter a report
This article explains how to use a multi-select list box to select several items at once, and open a report limited to those items.
12   Link   Use Automation to Print Microsoft Access Reports in Access 2000
By carrying out the OpenReport method of the DoCmd object, you can print Access reports from any Automation client application, such as Microsoft Visual Basic or the Microsoft Visual Basic Environment (VBE). This enables you to implement Access as the reporting component in your application solutions.
13   Link   How to reset the page number and the total page count for each group in a Microsoft Access report
This article describes how to reset the page number and the total page count for each group in a report that is created in Microsoft Access. You can use this method to reset the page number and the total page count for each group in a report when the page number appears in the Page Footer section of the report.

Note You must only use this method with a single-user database. If you try to use this method in a shared database, you may receive inconsistent results.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

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

Sponsored Links


Latest News



Powered by Joomla!. Designed by: Free Joomla 1.5 Theme, linux hosting. Valid XHTML and CSS.