Access Developer 7
01. Partial Payments 1 (30:54)
Create PaymentT
Create PaymentMethodT
Create PaymentF
SUM in Form Footer PaymentTotal
DSUM Payment Total
Popup, Modal Forms
Refresh Subforms
Forms!FName!Subform.Form!Field Notation
02. Partial Payments 2 (13:36)
vbExclamation
vbCritical
vbInformation
Don't allow Payment if PAID
Don't allow Payment if QUOTATION
Add Payments to Invoice Report
If No Payments, Handle NULL Value
NZ Function
03. Partial Payments 3 (22:29)
Add Horizontal Line over Payments
Hide Payments, Due if Null or Zero
CTRL-Y to Delete Line of Code
Visible Property
Section Header Build Event Code
Can Grow, Can Shrink for Section Header
Can Grow, Can Shrink for Text Boxes
Labels Don't Shrink
IsQuotation Not In Subform
Duplicate Fields in Both Tables
Specified Field Could Refer
Refer To More Than One Table
Add IsQuotation to OrderDetailQ
|