0. Welcome (5:07)
Building a Complete File Drop System with Previews, Launching, and Deep Linking
Adding image thumbnail previews to file drop form
Displaying file type icons for non-image files
Setting up a media folder for icons
Building open link or file function
Wiring up thumbnail click to launch attachments
Opening other Access databases with command line parameters
Handling opening of web links, files, and folders
Adding icons for web links and folders
Optimizing thumbnail loading with form's current event
Implementing late bound automation for Excel
Implementing late bound automation for Word
Opening Excel to a specific worksheet tab
Opening Word to a specific header section
Performing text search inside Word documents
Improving exit code for cleanup of objects and recordsets
1. File Drop, Part 4 (15:07)
How To Display File Type Icons And Image Previews In Microsoft Access
Building file thumbnails and previews for uploaded files
Displaying image previews for supported file types
Using file type icons for unsupported preview formats
Adding and configuring an Image control for thumbnail display
Writing the ThumbnailImage function to determine thumbnail source
Constructing the file path for custom file storage hierarchy
Handling null file names in the thumbnail function
Using the RightMost function to get file extensions
Importing helper functions into a global module
Setting up a Media folder for file type icon storage
Displaying specific icons for Word, Access, Excel, PDF, and text files
Assigning icon images based on file extension logic
Debugging issues with icon display and naming conventions
Automating error handling for locked databases
Testing thumbnail and icon display for various file types
2. File Drop, Part 5 (22:04)
Building OpenLinkOrFile Function, Open Access Databases with Command Line Parameters
Setting up an image click event to open files
Creating a reusable Open Link or File function
Passing a file path to a function via form fields
Adding a hidden field to store the full file path
Testing the hidden field with temporary visibility
Referring to the field in click events instead of rebuilding paths
Adding an optional link parameter to the function
Handling Excel files and opening to a specific sheet
Creating a separate function for Excel file opening
Handling Word documents and jumping to a specific Heading 1
Creating a separate function for Word file opening
Handling Access database files with command line parameters
Building the command string with optional parameters
Using ShellExecute to launch Access with parameters
Declaring and utilizing ShellExecute for API calls
Debugging argument type mismatches and handling variants
Utilizing the Nz function to handle null or empty values
Adding a "param" field to store command line parameters
Passing form field values as command line parameters
Testing command line parameter handling on database launch
3. File Drop, Part 6 (15:25)
Use ShellExecute to Open Files, Folders, and Unknown Types
Building hyperlink handling in the file drop system
Detecting HTTP and HTTPS web links
Launching web links from within the application
Handling mailto and other web link types
Fallback logic when file path is missing
Handling cases where file name or description is empty or null
Assigning proper icons for web links
Troubleshooting and debugging issues with hyperlink launching
Moving thumbnail image logic from control source to OnCurrent event
Optimizing thumbnail loading for continuous forms
Ensuring thumbnails only load for the current record
Error handling when loading thumbnail images
Launching files using ShellExecute
Launching folders in Windows File Explorer
Assigning folder icons based on trailing backslash detection
Distinguishing between files, folders, and web links in logic
4. File Drop, Part 7 (19:16)
Launch Excel or Word Files and Jump to Linked Content
Opening Word and Excel files using late binding
Automating Excel file opening from Access VBA
Activating a specific worksheet in Excel using VBA
Automating Word file opening from Access VBA
Bringing Word application window to foreground
Jumping to a heading in Word based on heading text
Fallback to plain text search in Word document if heading not found
Error handling and cleanup for Office automation objects
5. What's Next? (3:49)
Developer 52 Review and What’s Coming in Developer 53
This is a course outro and preview message, not a tutorial. It briefly summarizes what was covered and hints at future lessons, but does not contain in-depth instruction on any topic.
