Access Links

Access Links

Access Reports - Tips and Tricks

Miscrosoft access Reports - links to articles that show how to do some great stuff with Access Reports
  • Hits: 2008
    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
  • Hits: 2337
    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.
  • Hits: 2118
    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.
  • Hits: 2012
    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
  • Hits: 2476
    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.
  • Hits: 1519
    Leader Dots by Stephen Lebans
    a database containing functions to allow a user to fill in the space between 2 controls with leading dots.
  • Hits: 1447
    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
  • Hits: 1846
    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.
  • Hits: 2174
    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 WindowsSystem32 folder.
  • Hits: 1869
    Reset page numbers for each group in a report
  • Hits: 2113
    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.
  • Hits: 1701
    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.
  • Hits: 2750
    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.
  • Hits: 1161
    How to create a dynamic crosstab report in Access 2002 and later

    You can use Microsoft Access 2002 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 following example uses starting dates and ending dates that are entered on a form as the parameters in a crosstab query. When a button on the form is chosen, Microsoft Visual Basic for Applications (VBA) functions run the crosstab query that creates a dynaset. The contents of the dynaset are then presented in a report.

  • Hits: 285
    How To Watermark An Access Report

    As any regular user of Microsoft Word will know, it’s possible to create a document with a ‘watermark’ printed on the background of documents. (A watermark being a semi-transparent image that appears to sit below the text on a page)

    The ability to watermark an Access report isn’t built in, but with a little bit of work this feature can easily be replicated. (To create your watermark you will need a decent graphics manipulation package such as Photoshop, Paintshop Pro, the Gimp or Paint.NET [click here] )

Latest News