ACC2: List of Categories and Examples in SOLUTION.MDB

• Microsoft Access version 2.0

SUMMARY

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

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