Microsoft Solutions Database - Lots Of Free Help

Microsoft Solutions Database - Lots Of Free Help

Tucked away in the Microsoft Office 97 samples directory is a file called Solutions.mdb This page gives a brief outline of all the different things that you are likely to find in that database. This database was discontinued with Access 2000 (along with the Orders.mdb). But you can still download it at the following location. It did appear in the 2000 developer edition. And then it disappeared completey from XP Developer. Pity ! Try these download locations

Read more at this location or http://support.microsoft.com/?kbid=248674

Download from Garry's Special collection here and don't forget to sign up for Garry's newsletter here

General Application Help

Examples.Description	ObjectName	ObjectType
Close all database objects when you exit the application.	DeveloperSolutions	Form
Create an informational form that users can turn off.	SolutionsIntro	Form
Create a main menu form.	DeveloperSolutions	Form
Create an About dialog box.	AboutSolutions	Form
Create a startup form.	Startup	Form
Create a custom menu bar for a form.	EditProducts	Form
Create a toolbar that has custom buttons.	EnterOrEditProducts	Form
Get information from a user in a dialog box.	EmployeeSalesDialogBox	Form
Change toolbars in response to events.	EnterOrEditProducts	Form

Sample forms.

Examples.Description	ObjectName	ObjectType
Startup	Startup	Form
LimitListContents	LimitListContents	Form
EnterOrEditProducts	EnterOrEditProducts	Form
EditProducts	EditProducts	Form
SalesTotals	SalesTotals	Form
DeveloperSolutions	DeveloperSolutions	Form
AddAllToList	AddAllToList	Form
EmployeeSalesDialogBox	EmployeeSalesDialogBox	Form
AboutSolutions	AboutSolutions	Form
ShowSales	ShowSales	Form
SolutionsIntro	SolutionsIntro	Form
CustomersDialog	CustomersDialog	Form
CustomerPhoneList	CustomerPhoneList	Form
AddCategory	AddCategory	Form

Query by form.

Examples.Description	ObjectName	ObjectType
Use a custom function in a subform's SELECT statement.	ShowSales	Form
Show progressively more detail about a subject.	SalesTotals	Form
Use two subforms on a form.	SalesTotals	Form

Using queries with forms and reports.

Examples.Description	ObjectName	ObjectType
Use a parameterized query in an event procedure.	EmployeeSalesDialogBox	Dialog
Limit the contents of one list based on the value selected in another.	EditProducts	Form
Create a crosstab query for a report.	SalesLetter	Report
Use a custom function in a subform's SELECT statement.	ShowSales	Form
Use a totals query as the record source for a subform.	SalesTotals	Form
Limit the contents of a list based on the value selected in an option group.	LimitListContents	Form

Control what you print on reports.

Examples.Description	ObjectName	ObjectType
Hide a section when it falls at the top of a page.	ShippingLog	Report
Print "Continued" at the bottom of a preprinted form.	Invoice	Report
Hide and show sections that print on a preprinted form.	Invoice	Report
Draw a circle around data to accentuate it.	SalesLetter	Report
Print a report based on criteria entered in a dialog box.	EmployeeSalesDialogBox	Dialog
Print the first and last entries on a page in the page header.	CustomerPhoneList	Report

Calculate totals on reports.

Examples.Description	ObjectName	ObjectType
Calculate row and column totals on a crosstab report.	EmployeeSalesDialogBox	Dialog
Show totals in a subreport.	SalesLetter	Report

Create advanced reports.

Examples.Description	ObjectName	ObjectType
Create a crosstab report with dynamic column headings.	EmployeeSalesDialogBox	Dialog
Create a multiple-column report.	ShippingLog	Report
Create a form letter.	SalesLetter	Report
Create a multiple-fact crosstab report.	SalesAverages	Report
Create a report for a preprinted form.	Invoice	Report
Add a page border to a report.	SalesLetter	Report

Sample reports.

Examples.Description	ObjectName	ObjectType
EmployeeSales	EmployeeSalesDialogBox	Dialog
ShippingLog	ShippingLog	Report
SalesLetter	SalesLetter	Report
Invoice	Invoice	Report
SalesAverages	SalesAverages	Report
CustomerPhoneList	CustomerPhoneList	Report

Work with combo boxes, list boxes, subforms, and subreports.

Examples.Description	ObjectName	ObjectType
Use two subforms on a form.	SalesTotals	Form
Add a new record to a list.	EnterOrEditProducts	Form
Show totals in a subreport.	SalesLetter	Report
Find a record based on a value you select from a list.	EditProducts	Form
Update a list after you change its contents.	EditProducts	Form
Limit the contents of one list based on the value selected in another.	EditProducts	Form
Create a list box that allows you to select and manipulate multiple objects.	CustomersDialog	Form
Use Visual Basic code to programmatically fill a list box.	CustomersDialog	Form
Add "(all)" to a list.	AddAllToList	Form
Limit the contents of a list based on the value selected in an option group.	LimitListContents	Form
Use a custom function in a subform's SELECT statement.	ShowSales	Form

Work with forms and controls.

Examples.Description	ObjectName	ObjectType
Get information from a user in a dialog box.	EmployeeSalesDialogBox	Form
Create a form in which you can enter or edit data.	EnterOrEditProducts	Form
Update a list to show current data.	EditProducts	Form
Change the color of a control based on the value in the control.	EditProducts	Form
Capitalize one or more letters in a field automatically.	EnterOrEditProducts	Form
Create an informational form that users can turn off.	SolutionsIntro	Form
Create a main menu form.	DeveloperSolutions	Form
Create a form in which you can edit but not enter records.	EditProducts	Form
Create an About dialog box.	AboutSolutions	Form
Create and view multiple instances of a form.	CustomerPhoneList	Form
Use the Calendar custom control to select dates.	EmployeeSalesDialogBox	Form
Use Visual Basic code to programmatically fill a list box.	CustomersDialog	Form
Create a list box that allows you to select and manipulate multiple objects.	CustomersDialog	Form
Create a startup form.	Startup	Form

The Web And Other Things

Examples.Description	ObjectName	ObjectType
Link tables at startup.	DeveloperSolutions	Form
Programming command bars	CommandBarsForm	Form
Browsing the World Wide Web	WebBrowseWeb	Form
Using hyperlinks	SolutionsHyperform	Form
Programming the Office Assistant	Assistant	Form
Browsing saved hyperlinks	WebBrowseTable	Form

Updated 2003-01 by Garry Robinson from GR-FX Pty Limited, Sydney, Australia