Hey folks, sorry for my extended absence. I've had a lot going on lately. I just wanted to let everyone know that I've been busy recording new videos. I just finished Access Expert Level 32. It should be posted on the web site in the next day or two. If you're on the Waiting List for it, you should get your copy very soon. I'll post the outline of what's covered below. Other than that, how has everyone else been?
----
00. Intro (4:10)
01. Single Letter Report Header (18:05)
Contact Report
Creating Group for Single Letter
Group by First Character
Display LEFT 1 Character
Group by Contact Name
IsNull to Show No Company Name
02. Report List Form (17:19)
List of All Reports in Database
MSysObjects Table
List of Type Values
Custom Report List Table
Report List Form and Listbox
Macro to Open Report
Build Event
On Click Event
03. Rank, Median, Mode (25:04)
SubQueries, SubQuery
Query Customers Less Than Average Employees
Rank Formula
Alias for a Table
Median Value "Good Enough"
Mode Value
Totals Query, Top 1 Value
Percentile Ranking
04. Intro to Macros (36:18)
Customer Mailing Labels
Create LabelT Table
Create LabelR Report
Insert Blank Records at Top
Cut and Paste
Create LabelF Form
Create View Labels Button
Print Preview Report
Macro to Insert Blank Records
Command Button Macro
GoToRecord New Record
SetValue
Show All Actions
Unsafe Actions
Form Macros v External Macros
Button to Run External Macro
Prompt For Loop Count Value
InputBox Function
Insert Blanks on Top of Label Sheet
RunMenuCommand
SelectRecord, SelectAllRecords
Cut, Paste
Button on Customer Form to Add Label
OpenForm
05. Review (5:12)