Hey folks... this is just to let you know that Access Advanced 6 is finished and online. You can watch it in the Theater and download it now. I'm working on adding the outline to the web site now. Enjoy.
---
00. Intro (4:38)
01. SQL Search Boxes (35:50)
Create Unbound Search Text Boxes
SQL Statement to Replace RecordSource
Build SQL Statement in a Text Box
Separate WHERE Clause Box
Multiple Conditions
02. Data Macros (17:40)
BeforeChange
If NumEmployees < 0
SetField
RaiseError
ProductT Add UnitCost, Markup
Auto Calculate UnitPrice
If [IsInsert] For Adding Records
After Update
Create a Log Table
="Updated " & [CustomerT].[CustomerID]
Macro Shortcut on Desktop
03. Review (7:42)