0. Introduction (8:33)
How To Build Reusable Popup Forms, Safe Record Deletion, and Drag-and-Drop Files in Microsoft Access
Opening modal pop-up form over active control
Positioning pop-up forms using screen coordinates
Making pop-up forms reusable for multiple controls
Storing calling form and control info with temp vars
Returning values from pop-up to original control
Creating public functions for pop-up logic reuse
Handling subforms with pop-up controls
Calculating control position on main forms and subforms
Managing pop-ups in continuous forms
Using class modules to encapsulate pop-up logic
Determining if a control is in a subform via code
Calculating pop-up form coordinates with a class module
Using helper modules for streamlined pop-up code
Building leftmost and rightmost string helper functions
Handling null and empty strings in string helpers
Deleting or archiving records safely in recordset loops
Avoiding cursor issues when deleting in loops
Processing records with business logic before deletion
Archiving records using an external SQL statement
Passing recordsets to functions for cleaner code
Implementing transactions and error handling for delete/archive
Setting up drag-and-drop file management in Access
Enabling users to drop files onto a form
Listening for Windows API file drop events in Access forms
Configuring folder structure for dropped files
Adding safety checks before accepting file drops
Verifying user context and database state before file drop
Copying dropped files to organized folders
Generating unique file names for dropped files
Creating linked file records in the database
Refreshing form and setting focus after file drop
1. Popup Over Control, Part 1 (17:06)
How To Open a Modal Pop Up Form Over the Active Control and Set Its Position in Microsoft Access
Creating a modal pop up form in Access
Positioning a pop up form over a clicked control
Capturing active form and active control in VBA
Calculating screen coordinates for form positioning
Using DoCmd.MoveSize to position forms
Passing values from the main form to the pop up
Returning values from the pop up to the calling control
Adding a reusable function for pop up positioning
Handling multiple controls using one click event handler
Modifying form properties for modal behavior in Access
2. Popup Over Control, Part 2 (11:49)
How To Send Values Back To Controls Using TempVars With Pop Up Forms in Microsoft Access
Using TempVars to store calling form and control
Passing values back to original control
Naming and coding the close-return button
Setting and clearing object variables for forms and controls
Assigning values to controls using VBA
Closing forms programmatically with AC save
Setting default buttons for Enter key submission
Moving event handler code to a global module
Creating and using a public event handler function
Assigning the popup function to multiple controls
Applying the popup feature to different forms and fields
Limitations and considerations with subforms
3. Popup Over Control, Ext Cut (11:40)
How To Open Modal Popup Forms Over Controls in Subforms with Row Positioning in Microsoft Access
Handle pop-up over controls when working with subforms
Dynamic positioning and logic for continuous forms
4. Popup Over Class Module (14:03)
How To Use Class Modules For Pop Up Forms With Subform Detection in Microsoft Access
Class module structure and initialization
Tracking calling form and calling control
Detecting if code is executing in a subform
Identifying the subform control from a form
Limitations of nested subforms in class logic
Exposing form and control objects with Property Get
Creating Get and Let property procedures in a class
Returning values from a modal pop-up form
Using ByRef and ByVal parameter passing in VBA
Calculating and returning pop-up coordinates
Handling pop-up position issues with subform scrolling
Implementing pop-up coordinate capping logic
Building and using a helper module for class interaction
Calling class-based pop-ups from form controls
Assigning modal form targets using class properties
Passing values from modal forms via the class
Inserting pop-up logic into multiple forms
Applying the class module to real-world Access forms
5. LeftMost, RightMost (9:41)
How To Create LeftMost And RightMost Helper Functions For Strings in Microsoft Access VBA
Building the LeftMost helper function
Building the RightMost helper function
Handling null and empty string values in functions
Returning Boolean from string comparison
Using LeftMost and RightMost in form events
Case sensitivity with Option Compare Binary
Case sensitivity using StrComp
Real-world use cases for LeftMost and RightMost
Implementing functions in global modules
Applying functions to queries and criteria
Differentiating between Left and Right string functions
Comparing string prefixes without character counting
6. rs.Delete in a Loop (18:12)
How To Safely Delete Records In A Recordset Loop And Avoid Skipping Errors In Microsoft Access
RS Delete basics with single records
Dangers of deleting inside a recordset loop
Cursor issues when deleting records during a loop
Problems with SQL Server and ODBC recordsets
Business logic for conditional deletion
Safe method for deleting with a separate SQL statement
Setting up a snapshot-type recordset for safety
Importance of adding WHERE and ORDER BY clauses
Passing a recordset to a function
Using ByRef to pass recordsets
Implementing custom business rule checks in a function
Archiving a record before deletion with INSERT INTO
Deleting records using db.Execute
Ensuring recordset stability during deletion
Handling duplicate primary keys in archive tables
Using a single CurrentDb instance with a db variable
Wrapping operations in a transaction for safety
Implementing dry run mode for testing deletions
Adding logging for archived records
Multi-user considerations and form locking
7. File Drop, Part 1 (16:04)
How To Enable Drag And Drop File Uploads With Windows API In Microsoft Access VBA Forms
Overview of drag and drop file handling in Access forms
Setting up Windows API calls for file drop detection
Adding the file drop listener module to Access
Enabling drag and drop on a specific Access form
Understanding and using the hwnd property
Wiring the listener to a form's OnLoad and OnUnload events
Capturing and displaying dropped file paths in VBA
Avoiding issues with the VBA editor during file drops
Brief explanation of EnsureFolder and FileNameOnly helper functions
Testing file drop functionality on an Access form
8. File Drop, Part 2 (18:15)
Prepare Your Database To Safely Store Dropped Files And Avoid Lockups
Organizing a folder structure for file drop storage
Creating a files subfolder for dropped files
Placing the database in a dedicated folder
Modifying the handle dropped file routine
Generating customer-specific folders for file storage
Using a VBScript to kill locked Access processes
Importing and using a module to detect open windows
Implementing IsWindowOpen to check for VBA editor
Disabling file drop if VBA editor is open
Changing form appearance when file drop is disabled
Updating form captions and background colors based on status
Ensuring customer ID is present before file drop
Updating the contact table to store file names
Displaying the file name in the contact form
Conditional logic to enable or disable file dropping
Providing user feedback when file drop is disabled
Debugging and compiling after code changes
Testing file drop safeguards with various form states
9. File Drop, Part 3 (21:07)
Store Dropped Files Automatically And Link Them To Your Records
Creating a folder structure for dropped files
Prompting developer to close the VBA editor before file drop
Detecting the source path of a dropped file
Ensuring the destination folder exists
Generating unique file names using date and timer
Copying files to the destination folder
Handling file copy errors with error trapping
Adding dropped files as linked records in the database
Populating database fields with file data
Refreshing and requerying the form after file import
Moving focus to the newly added file record
10. What's Next? (5:55)
Review of Topics Covered in Microsoft Access Developer 51 and What to Expect in Future Lessons
