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
