Access Developer 5
01. Pay Commissions 1 (15:21)
Add Commission Check ID to Com Table
Create Commission Check Table
Commission Select Query
Commission Check Employee Query
Commission Check Form
Combo Box to Select Employee
02. Pay Commissions 2 (20:38)
Commission List Box
Is Selected
Copy Between Two List Boxes
Drag and Drop Discussion
Click and Drag
Create ComList2
SQL UPDATE to Select Items
Totals for each List Box
DSUM Function
03. Pay Commissions 3 (20:17)
MsgBox vbYesNoCancel vbYes
SQL INSERT Check into Table
Add EmployeeID to CommissionT
Database Theory v Practice
Update CommissionT for Changes
04. Printing Checks 1 (15:23)
Convert Currency or Number to English
SpellNumber Function
Create a Global Module
Look up Largest Check Number in Table
Create New Check Number
05. Printing Checks 2 (20:30)
IsPrinted
Create Check Report
Blank Laser Printer Checks
Process Current Check
Print All Checks
Mark Printed
DoCmd.OpenReport acViewPreview
OnNoData Report Event
Mark ALL Commissions Selected
|