|
 Microsoft Solutions Database - Lots Of Free HelpTucked 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 |
Other Related Pages
The Workbench now
makes startup property management easier
Take the SQL Taste Test in
Access ADO
vb123 Professionals
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
Garry Robinson writes for a number
of popular computer magazines, is now a book author and has worked on
100+ Access databases. He is based in Sydney, Australia
| 
vb123.com.au
