0. Welcome (4:26)
How To Add Recycle Bin Delete, One-Click Word Docs, Batch Import, and MakeDir in Microsoft Access
Error handling improvements for file deletions
Implementing a recycle bin system in Access
Moving deleted files to Windows Recycle Bin using PowerShell
Creating and using a Recycle table for deleted records
Verifying records and files before deletion
One-click creation of blank Word documents from Access
Generating unique file names for Word documents
Saving Word documents to specific customer folders
Registering new files in the database system
Automating opening of new Word documents for editing
Building a recursive MakeDir VBA function
Creating nested folder hierarchies programmatically
Batch importing all files from a selected folder
Integrating an import folder system into Access
1. Recycle Files (31:35)
Sending Deleted Files to the Windows Recycle Bin from Microsoft Access
Adding robust error handling for Excel file and sheet access
Adding error handling for Word document automation
Ensuring records are saved before file access in VBA
Implementing custom error handlers at specific code points
Updating button click events to save records with Me.Dirty = False
Displaying user-friendly error messages in VBA
Copying related table structure for a recycle bin table
Customizing the recycle bin table to handle multiple deletions
Adding a recycled date field with default value Now
Building a delete button workflow to recycle records and files
Implementing user confirmation with a custom AreYouSure function
Checking for valid record and filename before attempting delete
Validating file existence before recycling
Building full file path dynamically in VBA
Copying records into the recycle bin table via SQL
Deleting the original record after recycling
Automating file deletion by invoking a PowerShell script using VBA
Creating a global VBA function to call PowerShell and recycle files
Returning and interpreting exit codes from PowerShell process
Testing the recycle bin integration and deletion workflow
Restoring files from the Windows recycle bin through Windows
Reviewing integration versus standalone recycle bin techniques
Commenting and documenting VBA code for maintainability
Debugging and compiling the updated VBA code
2. Create New Word Doc (15:25)
Create a New Word Document With One Click and Save to a Customer Folder in Microsoft Access
Creating a button in Access to generate a new Word document
Prompting user for document description via InputBox
Automatically generating a unique file name using description and timestamp
Saving the new Word document to a database folder
Using VBA to automate Word document creation with late binding
Saving and closing a new Word document via VBA
Using SaveAs2 method to save Word documents in VBA
Registering the new document in the Access database
Moving the new file to the customer's folder using a custom function
Deleting the original temporary file after registration
Opening the new Word document for editing from Access
Assigning and updating the document description in the Access database
Debugging and testing the document creation process
Ensuring file naming consistency and timestamp application
Handling user cancellation gracefully during document creation
3. Recursive MkDir (21:59)
How To Create Nested Folders With a Recursive MkDir Function in Microsoft Access VBA
Explanation of recursion with folder paths
Building a recursive make-dir function in VBA
Validating folder paths for drive letters
Removing trailing backslashes from folder paths
Checking if a folder exists using Dir
Extracting the parent folder with InStrRev
Recursive calls to ensure parent folders exist
Creating nested folders using VBA
Error handling for folder creation
Testing the myMakeDir function in Access
4. Import Folder (18:25)
Creating a Shared Import Folder Workflow in Microsoft Access with Dir Loop
Defining a shared import folder location using a global constant
Opening the import folder from an Access form
Creating a button to open the import folder
Creating a button to batch import all files from the folder
Implementing classic VBA Dir loop for batch file import
Explaining Dir loop pitfalls and function interference
Safe alternatives to Dir loops: FSO and arrays
Indexing and importing files into database
Handling and deleting files after import
Adding a button to import a specific file (snap.jpg)
Using an external screenshot utility for file imports
Verifying and error checking file existence before import
5. What's Next? (4:04)
Reviewing Recycle Bin, Recursive Folder Creation, and Multi-File Drag and Drop in Microsoft Access
This is the wrap-up segment for Access Developer 53, describing content from the tutorial and mentioning future plans and feedback process. No new technical topics are presented or covered in this section.
