0. Welcome (5:56)
How To Build a Dynamic Kanban Board With Drag and Drop Columns in Microsoft Access
Building a dynamic Kanban board in Microsoft Access
Converting a fixed Kanban board to a developer-level project
Making Kanban columns configurable
Storing and retrieving control positions and sizes in a table
Using VBA to move and resize controls at runtime
Showing and hiding form controls dynamically
Displaying a variable number of Kanban columns based on table settings
Hiding and compacting unused controls
Centering navigation buttons and info panel on a form
Implementing safety checks for dynamic layouts
Using mouse events to track drag and drop actions
Calculating mouse X and Y coordinates in form controls
Determining target list box for record drop
Implementing drag and drop between list boxes
Moving records between Kanban columns with drag and drop
Changing the mouse pointer during drag operations
Polishing the form interface for interactive use
Making forms adapt their layout at runtime using VBA
Making interactive, flexible, and reusable form layouts in Access
Techniques for forms that respond to user actions
1. Kanban Board 1 (27:22)
Dynamic Form Layouts for Multi Column Kanban Boards with Runtime Positioning
Building dynamic Kanban board layouts in Access
Creating multiple list boxes and labels for columns
Storing control coordinates in a table
Capturing control positions with a button
Looping through controls to save their properties
Adding and configuring fields in the status table
Saving and restoring label and list box colors
Avoiding reserved words for table field names
Displaying only visible Kanban columns at runtime
Dynamically arranging and resizing controls based on table data
Automatically resizing the form to fit active columns
Using recordsets to manage runtime layout changes
Synchronizing form and table data for dynamic interfaces
2. Kanban Board 2 (19:23)
Dynamic Box Counts and Auto Centered Controls for Runtime Kanban Layouts
Tracking and storing the active box count in memory
Using TempVars to share box count across procedures
Limiting navigation based on visible boxes
Hiding and resizing unused list boxes at runtime
Automatically centering control buttons on the form
Calculating dynamic button positions with offsets
Centering and resizing an info line control at the bottom
Adding safety checks for valid box (status) count range
Implementing form open event safety validation
Polishing the interface for dynamic column changes
3. Kanban Board 3 (22:30)
Using Mouse Coordinates and Control Positions to Detect List Box Drop Targets
Implementing drag and drop using mouse events
Detecting mouse up position in list boxes
Converting mouse coordinates to form-relative positions
Identifying which list box received the drop
Calculating control boundaries for hit testing
Looping through controls to match drop location
Handling MouseUp event in multiple list boxes
Passing coordinates to a centralized handler
Working with Single data types for coordinates
Debugging and testing drag-and-drop functionality
4. Kanban Board 4 (33:01)
Building Drag and Drop List Box Movement with Custom Mouse Pointer Changes
Implementing full drag and drop behavior between list boxes
Tracking source and destination list boxes in Access
Moving records with mouse events in Kanban board
Cleaning up Access drag and drop visual artifacts
Handling mouse pointer changes during drag and drop
Updating customer status based on list box moves
Using Nz to handle null values in Access forms
Requerying list boxes after drag and drop
Avoiding requery errors by shifting focus
Preventing redundant moves when source and destination are equal
Fixing list box and label positions with an admin button
Making maxLists a global variable for design fixes
Restoring default mouse pointer after drag
Implementing CleanExit to reset mouse state
Maintaining compatibility between drag and button actions
Handling edge cases to prevent stuck selections
Training users for drag and drop workflow quirks
Synchronizing TempVars for current selection
Refreshing forms to eliminate leftover selection artifacts
5. What's Next (2:06)
How To Build a Dynamic Kanban Board With Drag and Drop Columns in Microsoft Access
Building a dynamic Kanban board in Access
Configurable Kanban board columns
Creating runtime layouts for forms
Implementing drag and drop with mouse events
Using VBA for interactive form behavior
Applying Kanban techniques to other Access projects
