01. Homework Plus (13:16)
Select & Deselect All Buttons
Both List Boxes
One Sub Handles All 4 Cases
Count of Records Selected
IIF for Customer or Customers
02. Bug Fix, Visual Glitch (18:05)
Bug in List Box Form
Deselect Items as you Change Table Value
Visual Glitch in Listbox Selection
03. Formatting, Colors in a List Box (34:31)
Make a Continuous Subform Instead
Sales Rep Table
Conditional Formatting Expression Is
Make SubForm
No Link Master or Link Child Fields
Expression = SalesRepID
Requery On Current
CustomerID.SetFocus Get Rid of Selection
On Mouse Move
Change Screen Pointer
Screen.MousePointer
04. Recordsets Part 1 (19:36)
What is a Recordset
Why use Recordsets?
Talk about DAO v ADO
Create our First Recordset
Dim Database, Recordset Objects
CurrentDB
OpenRecordset
Close Objects
Set to Nothing
Display DB and RS Names
05. Recordsets, Part 2 (32:00)
Displaying FirstName
rs!FirstName
rs("FirstName")
rs.MoveFirst
rs.MoveNext
While Wend Loop Thru Records
Avoid Endless Loops
Add a Loop Counter
Don't Use Spaces!
rs.EOF rs.BOF
Dealing with No Records
Creating Unbound Text Box
Value List
Adding Records
ListBox.AddItem
Ampersand Button Caption Alt-A
Default Button for Form
Add from RecordSet to ListBox
RemoveItem from Single ListBox
ListIndex