01. Export Report as HTML 1 (11:17)
Part 1: TechHelp
Perform Export
02. Export Report as HTML 2 (14:43)
Part 2: Extended Cut
Create Shortcut to Google Drive Folder
Make Folder Public
03. FTP File to Web Server (16:11)
Explain Command Line FTP
Create a Script File
Perform FTP Operation
04. Convert Currency Part 1 (15:14)
Create Conversion Table
Lookup Value
Do Conversion in Query
05. Convert Currency Part 2 (16:59)
Table for Multiple Rates
Display All Currencies
Customer Currency
Put Conversion on Invoices!
06. Auto Update Rates from Web API (23:15)
MSXML2.XMLHTTP Object
Opening Call to URL
Getting ResponseText
FindBetween Function
Updating Rates in CurrencyT
07. Groups 1 (14:48)
Group Field
Simple Wildcard Search
08. Groups 2 (25:06)
Group Table
Pick from List
Filter on Customer List
09. Group Search (35:22)
Search Table
On Delete Issues
Proper Way to Handle Form Delete Event
More Fun with TempVars
Friendly Errors For Duplicate Values
BeforeUpdate, Cancel Event, Undo Changes
ANY Groups
ALL Groups