00. Intro (7:18)
01. Display External Images (17:29)
Create Customer Table
Setup File Attachments Folder
Copy Images to Folder
Create Customer Form
Display Customer Image on Form
Multiple Attachments Per Customer
Setup Attachments Table
Display File Extensions
Hide Extensions for Known File Types
Attachments Subform
02. Shell Command (23:33)
Command Button Build Event
SHELL Function
vbNormalFocus
System Path Variable
Command Prompt
Determining What Program Opens a File
On Double Click Event
Dealing with Spaces in File Names
Launching Internet Explorer
Command Line Arguments Switches
03. ShellExec Command (20:57)
ShellExecute Function
Create the ShellExec Sub
Code Sample Table and Form
Choose Default File Handler
Open Web Page with ShellExec
Open Google Maps to Customer Address
Build Google Maps URL
Replace Function
Open Folder with Windows Explorer
Sending Email with Mailto
04. ShellExec Command Advanced (7:24)
Private and Public Constants
Error Handling
Other OPEN type arguments
05. Review (2:35)