ACC: List of Categories and Examples in Solutions.mdb (95/97)

• Microsoft Access versions 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

The Solutions sample database (Solutions.mdb) included with Microsoft Access 97 and Microsoft Access version 7.0 contains a number of examples of commonly requested tasks that can help you design your database applications more effectively. This article lists all of the categories and examples in the Solutions.mdb.

MORE INFORMATION

Following are the categories and examples in the Solutions.mdb database. 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

• AboutSolutions
• AddAllToList
• AddCategory
• CustomerPhoneList
• CustomersDialog
• DeveloperSolutions (Solutions in Microsoft Access 7.0)
• EditProducts
• EmployeeSalesDialogBox
• EnterOrEditProducts
• LimitListContents
• SalesTotals
• ShowSales
• Solutions
• SolutionsIntro
• 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.
• 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 list box that allows you to select and manipulate multiple objects.
• Create a main menu form.
• Create a startup form.
• Create an About dialog box.
• Create an informational form that users can turn off.
• Create and view multiple instances of a form.
• Get information from a user in a dialog box.
• Update a list to show current data.
• Use the Calendar custom control to select dates.
• Use Visual Basic code to programmatically fill a list box.

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

• Add "(all)" to a list.
• Add a new record to a list.
• Create a list box that allows you to select and manipulate multiple objects.
• Find a record based on a value you select from a list.
• Limit the contents of a list based on the value selected in an option group.
• Limit the contents of one 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 two subforms on a form.
• Use Visual Basic code to programmatically fill a list box.

Query by form

• Show progressively more detail about a subject.
• Use a custom function in a subform's SELECT statement.
• Use two subforms on a form.

Using queries with forms and reports

• Create a crosstab query for a report.
• Limit the contents of a list based on the value selected in an option group.
• Limit the contents of one 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.

• CustomerPhoneList
• EmployeeSales
• Invoice
• SalesAverages
• SalesLetter
• ShippingLog

Create advanced reports

• Add a page border to a report.
• 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 sections that print on a preprinted form.
• Print "Continued" at the bottom of a preprinted form.
• Print a report based on criteria entered in a dialog box.
• Print the first and last entries on a page in the page header.

Calculate totals on reports

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

Use multiple databases

• Link tables at startup.

What's New in Microsoft Access 97

- Browsing saved hyperlinks. - Browsing the World Wide Web. - Programming command bars. - Programming the Office Assistant. - Using hyperlinks.

REFERENCES

For a list of categories and examples in SOLUTION.MDB (2.0), please see the following article here in the Microsoft Knowledge Base: