Microsoft KB Archive/111782

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.