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

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.

Sample reports

• 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.

The following categories have been added to the Solutions.mdb file that is included in Microsoft Access 97.

What's New in Microsoft Access 97

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