Access Advanced 4 is done, recorded, and online for viewing. I just need to put together the full outline for the web site, but if you're curious, here's what it covers:
00. Intro (3:48)
01. Password to Open Form (14:23)
InputBox to Collect Password
SettingT Table for Global Settings
SetTempVar to DLOOKUP Password
02. Full Sheet of Same Customer Label 1 (9:02)
Non-Macro Method
Create Mailing Labels Using Wizard
Use Forms!CustomerF for Data
Set up Bogus Table for 30 Records
03. Full Sheet of Same Customer Label 2 (20:22)
Individual Labels with SendKeys Method
OpenTable Command
GoToRecord Command
SendKeys Command
Loop Method with External Macro
Create Label Form
SetValue Labels from Customer Form
RunMacro Command
Repeat Count to Loop
Repeat Expression
04. New Method for Quote v Invoice (6:07)
Quote or Invoice Word on Report
Build Event of Detail Section
SetProperty Caption
Make IsQuotation Invisible
05. Macro Groups and Submacros (9:49)
Macro Group
Comment
Submacro
RunMacro MacroName.SubMacro
Default Macro Action
One Macro to Open Multiple Forms
06. Review (3:59)