Knowledge Base |

# ACC2: List of Categories and Examples in SOLUTION.MDB

Article ID: 111782

Article Last Modified on 7/8/2002

APPLIES TO

- Microsoft Access 2.0 Standard Edition

This article was previously published under Q111782
Moderate: Requires basic macro, coding, and interoperability skills.

## SUMMARY

The sample application Solutions (SOLUTION.MDB) included with Microsoft Access version 2.0 contains many examples of common tasks that you can use to help you design your database applications. This article lists all the available categories and examples in the Solutions sample application.

## MORE INFORMATION

These are the categories and examples in the Solutions sample application. Each category is followed by all the examples for that category:

       Build a Microsoft Windows interface
       -----------------------------------------------------------

        - Change toolbars in response to events
        - Close all database objects when you exit the application
        - Create a custom menu bar for a form
        - Create a main menu form
        - Create a startup form
        - Create a toolbar that has custom buttons
        - Create an About dialog box
        - Create an informational form that users can turn off
        - Get information from a user in a dialog box

       Sample forms
       ----------------------------

        - About Solutions
        - Add All To List
        - Add Category
        - Edit Products
        - Employee Sales Dialog Box
        - Enter or Edit Products
        - Find Customers
        - Limit List Contents
        - Reattach NWIND
        - Sales Totals
        - Show Sales
        - Solutions
        - Solutions Intro
        - Startup

       Work with forms and controls
       ------------------------------------------------------------------

        - Capitalize one or more letters in a field automatically
        - Change the color of a control based on the value in the control
        - Change the color of a section and control at run time
        - Clear the values in unbound text boxes and a subform
        - Control when you go to a new record
        - Create a form in which you can edit but not enter records
        - Create a form in which you can enter or edit data
        - Create a main menu form
        - Create a startup form
        - Create an About dialog box
        - Create an informational form that users can turn off
        - Get information from a user in a dialog box
        - Remove the minimize and maximize buttons from a form
        - Update a list to show current data

       Get more mileage from combo boxes, list boxes, subforms and subreports
       ----------------------------------------------------------------------

        - Add "(all)" to a list
        - Add a new record to a list
        - Find a record based on a value you select from a list
        - Limit the contents of a list based on the value selected from an
          option group
        - Limit the contents of a list based on the value selected in
          another
        - Show totals in a subreport
        - Update a list after you change its contents
        - Use a custom function in a subform's SELECT statement
        - Use criteria from the main form to set the subform's RecordSource
          property
        - Use two subforms on a form

       Query by form
       --------------------------------------------------------------------

        - Find a record based on a value you select from a list
        - Find records based on values in one or more fields
        - Show progressively more detail about a subject
        - Use a custom function in a subform's SELECT statement
        - Use criteria from the main form to set the subform's RecordSource
          property
        - Use part of a value to specify criteria
        - Use two subforms on a form

       Using queries with forms and reports
       --------------------------------------------------------------------

        - Create a crosstab query for a report
        - Create a SELECT statement for a form based on user input
        - Limit the contents of a list based on the value selected from an
          option group
        - Limit the contents of a list based on the value selected in
          another
        - Use a custom function in a subform's SELECT statement
        - Use a parameterized query in an event procedure
        - Use a totals query as the record source for a subform
        - Use criteria from the main form to set the subform's RecordSource
          property

       Sample reports
       ----------------------

        - Customer Phone List
        - Employee Sales
        - Invoice
        - Sales Averages
        - Sales Letter
        - Shipping Log

       Create advanced reports
       --------------------------------------------------------

        - Create a crosstab report with dynamic column headings
        - Create a form letter
        - Create a multiple-column report
        - Create a multiple-fact crosstab report
        - Create a report for a preprinted form

       Control what you print on reports
       ----------------------------------------------------------------

        - Draw a circle around data to accentuate it
        - Hide a section when it falls at the top of a page
        - Hide and show controls based on the value in another control
        - Hide and show sections that print on a preprinted form
        - Print "Continued" at the bottom of a preprinted form
        - Print report criteria that was entered in a dialog box
        - Print the first and last entries on a page in the page header
          Repeat a group name at the top of a column or page

       Calculate totals on reports
       -------------------------------------------------------

        - Calculate row and column totals on a crosstab report
        - Show totals in a subreport

       Use multiple databases
       ---------------------------

        - Attach tables at startup

Additional query words: Designing

Keywords: kbinfo kbusage KB111782