Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Home > Courses > Access > Developer > D29 > D29 Outline < D28 Outline | D30 Outline >
 Access Developer 29 01. Product Components 1 (15:28) PartT, ProductXPartT & Q ProductF, ProductXPartF 02. Product Components 2 (24:33) Profit = Price - Cost Margin = Profit / Price Markup = Profit / Cost Buttons to Adjust All Three Algebra to Solve Equation for Price MathPapa.com Albegra Calculator Bring Price Up to 99 Cents 03. FIFO Stock Rotation 1 (37:16) FIFO: First In, First Out FEFO: First Expired, First Out Update UnitT and UnitF Add DateAdded, ExpirationDate, OrderID Change Sort: ExpirationDate, DateAdded, UnitCode Resize ProductF In Code Ask for Expiration Date If Specific Unit Scanned, Use It Warn if Expired Pick the Oldest Unit NOT Expired, Not on Order Assign Order ID to UnitT 04. FIFO Stock Rotation 2 (14:42) Deleting Item from Order Put Back Into Inventory I Don't Like Delete Events OnDelete, BeforeDeleteConfirm, AfterDeleteConfirm Turn Off Record Selectors Set Allow Deletions to NO Manual Warning with MsgBox Don't Allow Qty > 1 if Serial Numbered Item Lock Serial Number Field
 Check out these other pages that may be of interest to you:
 11/25/2022 Application Title 11/24/2022 Full HTML Editor in Access 11/24/2022 Change Database Title 11/23/2022 Other Names 11/21/2022 Check Icon File 11/21/2022 Check Icon File 11/18/2022 Archive Records 11/17/2022 InStr Function 11/16/2022 Numbers As Text 11/15/2022 Merge Tables