1. Reservation System (45:14)
Reserve an Item, Tool, Room, etc.
Before Update Event Logic
Must be Future, Up to 1 Year
Minimum 1 Day Rental
Maximum 2 Week Rental
Conflict Resolution
2. Copy Order with Details 1 (34:22)
Copy Record with Children "Messy" Way
Copy Paste Manually
Copy with Duplicate Record Button
Copy with the Messy Method
DoCmd.GoToControl
DoCmd.RunCommand
acCmdSelectRecord
acCmdCopy
DoCmd.GoToRecord
acCmdPaste
acCmdSelectAllRecords
acCmdPasteAppend
DoCmd.Echo On/Off
Deleting Child Records
Don't Rely on Cascade Deletes
Referential Integrity Not in Linked Tables
Find Orphan Records
3. Copy Order with Details 2 (27:31)
Copy Record with Children "Proper" Way
Loop Through Fields in a Recordset
Dim Fld As Field
For Each Fld in rs.Fields
Fields Collection of a Recordset
Fld.Name
Copy Order Record
Copy All Details in Loop
Future Proof the Copy!