We will begin by learning how to open a Recordset
with an SQL statement.
You will learn how to load a list of customers
into a Listbox using your Recordset.
You'll learn how to generate a list of active
states based on which states appear in your customer table. This way
you don't have to see a list of all 50 states if you have no customers
from most of them.
You'll learn how to modify the records in your
Recordset. In this case, we'll make a button that you can click once and
it will increment the number of seminars that each customer has
You will learn how to work with Multi-Select
List Boxes so you can pick one or more specific records in a listbox
to work with.
You'll learn how to add new records to
your table and listbox using the recordset.
You'll learn how to delete the selected
Finally, you'll learn how to use db.Execute
to run an SQL statement.
Access 321 - Course Outline
1. Customer ListBox, Part 1
Open Recordset with SQL
SQL WHERE Statement
Adding Items to a ListBox
Row Source Type: Value List
Access 2000 Users: No AddItem
2. Customer ListBox, Part 2
Add the ID
Clearing Your List Box
Combo of Unique States
3. Edit Records
Editing One Record
Editing Multiple Records
Loop Through And Edit
4. Multi-Select List Boxes
Simple v. Extended
Loop Through Items With ListCount
5. Adding & Deleting Records
Adding a Record
Sorting Our Customer List
Always Have an Are You Sure? Prompt
INSERT INTO SQL Command