1. Get Report Data from Form (11:25)
Download the D26 L5 Database
Examine the CustomerSearchF
Create CustomerSearchR Report
Bind Originally to CustomerT
Create Open Report Button
Report_Open (On Open) Event
Report RecordSource Property
Set to RowSource of CustomerList
On No Data Event
Same Thing with CustomerRecordsetF
Search Form Data For Report / To Report
2. Customer Pricing 1 (18:20)
Customer Specific Pricing Table
Dlookup Custom Price
IIF Compare Prices
Display Final Price List
3. Customer Pricing 2 (11:17)
Custom Pricing in Combo
Add to Invoice
4. Customer Pricing 3 (15:33)
If Price Changed, Ask to Make Custom Pricing
If Exists, Update. If Not Add New
Check for BOF, EOF
Add or Edit Accordingly
Subform to Edit Custom Pricing
5. Time & Billing 1 (25:47)
Create Work Table, Form
Calculate Total Billable Time
Calculate Unbilled Time
Option to Show All, Unbilled
6. Time & Billing 2 (32:16)
Start / Stop Timer
Lock Controls on Form
Bill in 15 Minute Increments
7. Time & Billing 3 (23:37)
Create Invoice Button
Create Order, Get ID
Recordset to Create Order
Recordset to Loop Thru WorkT
Create Order Detail Items
Update Customer Address Info
8. Time & Billing 4 (24:38)
Aggregate Query Unbilled Work
Listing for All Customers
UnbilledWorkF with Listbox
Convert Code to Global Mod
RS Loop Thru Unbilled Work
Generate All Invoices
9. Print & Email Invoices (37:30)
Print all Unpaid Invoices
Email all Unpaid Invoices
CDO.Message Send Email
Export Invoice Report as PDF
Docmd.OutputTo
Option to Skip Printing Cust w Emails
Hide Order Form