|
||||||
|
Half of New Access Seminar Available By Richard Rost I've posted the first 22 lessons of my Access Work Order Seminar to the Online Theater. It's currently over 4 hours long, but one of my customers is really anxious to get started on it, so I've decided to post the first half NOW, and the rest when it's finished. Access Work Order Seminar Outline 1. Plan Database (11:33) Tables Relationships Reports 2. Customer Tables (11:58) CustomerT LocationT UnitT 3. Customer Form (11:20) Make Customer Form Locations List Box SQL RowSource Custom WHERE Condition Forms!CustomerF!CustomerID OnCurrent Event LocationList.Requery 4. Location Form 1 (12:27) Build Location Form Customer Combo Box Open Location From CustomerF DoCmd.OpenForm Code Where Condition OnDblClick Event 5. Location Form 2 (9:03) Add New Location Open Form to Add Records Form Field Default Value Tab Stop Property Requery Across Forms On Error Resume Next 6. Unit Form 1 (12:47) Build Unit Form 7. Unit Form 2 (9:19) Limit List of Locations Change RowSource in VBA Notes 8. Using Subforms (10:23) Creating Location SubForm Creating Unit SubForm Continuous Forms Form Header/Footer 9. Customer List (11:00) Build Customer List Form Open Customer Button New Customer Button 10. Work Order Form 1 (7:33) Build Work Order Table Design Work Order Form 11. Work Order Form 2 (11:14) Dynamic Combo Boxes Locations by Customer Units by Location Enabled Property DropDown Method SetFocus Method 12. Work Order Form 3 (11:58) Blanking Combo Boxes OnCurrent Event Enable/Disable if Needed Requery Combo Boxes Again 13. Work Order Form 4 (9:22) DLOOKUP Name & Address Info Dim Variable 14. Work Order Form 5 (12:17) NZ Function Dealing with NULL problems Double-click to Open Forms DoCmd.OpenForm 15. Status, Priority (12:52) Status Table Sorted Status Query Priority Table Sorted Priority Query Status, Priority Combo Boxes Default Combo Values Default Requested Date 16. Create Work Order (12:57) Button on Customer Form Button on Location Form Button on Unit Form 17. Work Order Query (6:35) Master Work Order Query Relationships Outer Joins 18. Work Order List 1 (18:57) List of Work Orders Listbox on Customer Form Listbox on Location Form Listbox on Unit Form Limit to Current Record Double-click Open Event OnCurrent Event Updated 19. Work Order List 2 (10:26) Requery Work Order List On Error Resume Next Triple State Check Box Show Closed Work Orders Show Open Work Orders Show Both Closed and Open 20. Work Order List Form (19:48) Master Work Order List Show Closed Work Orders Change Sort by Column Headers Main Menu Form 21. Labor Form 1 (9:01) Form to Track Labor Items Continuous Forms 22. Labor Form 2 (8:53) Calculate Billable Hours Rounding Time Values SUM Total Page Footer v. Form Footer DateDiff Function Topics Yet To Cover: - Multiple Categories for Work Orders - Finish Labor Tracking - Materials Tracking - Products Table/Form - Invoicing - Scheduling of Workers/Appointments Reports: - Work Order List - Individual Work Orders - Schedule for everyone - Schedule for each worker - Invoices IF YOU CAN THINK of something that's NOT on this list that you'd like to see, email me or post it here!
|
||||||||||||||||||
|
| |||
| Keywords: access work order seminar job costing Page Tag: whatsnew PermaLink Half of New Access Seminar Available |