MAKE SURE YOU WATCH THE TECHHELP VIDEOS FIRST! See links on Lesson 1.

Lessons

•  01. Kanban Board 1 (27:22)
•  02. Kanban Board 2 (19:23)
•  03. Kanban Board 3 (22:30)
•  04. Kanban Board 4 (33:01)
• Total Runtime: 1 hour 42 minutes

Lesson Summary

Lesson 1: Dynamic Multi-Column Kanban Board Setup - In lesson one we begin constructing a dynamic Kanban board system in Microsoft Access with runtime-configurable form layouts and columns. We will walk through storing control positions in a table, automatically resizing and rearranging the form, and displaying only the necessary list boxes based on user configuration. The lesson covers setting up the necessary fields and logic to support dynamic Kanban columns and demonstrates how to save and restore layout parameters for each box on the form, providing the foundation for a customizable Kanban board interface.

Lesson 2: Box Counts & Auto-Centered Controls - In lesson two, we continue enhancing our Kanban Board by refining the dynamic layout. We will walk through tracking the active box count for future use, automatically centering controls based on the number of columns, and cleaning up unused list boxes at runtime. We will also discuss adding safety checks to ensure valid status options and polish the interface to respond correctly as the visible columns change. Finally, we will talk about ways to handle some potential user and design issues as the application grows.

Lesson 3: Detect Drop Targets with MouseUp - In lesson three of the Kanban Board tutorial series, we will walk through implementing real drag-and-drop functionality for your Kanban board using mouse up events and coordinate math. I will show you how to detect where the mouse is released, convert those coordinates to the form's positioning system, and determine which list box receives the dropped item. We'll also discuss handling form centering issues after resizing and use code examples to track the drop location, allowing records to be moved between stages. This lesson focuses on making true drag-and-drop between list boxes possible for your Kanban Board project.

Lesson 4: Drag & Drop, Custom Mouse Pointer - In lesson 4 of the Kanban Board series, we complete the Kanban board system by implementing full drag and drop behavior in Microsoft Access, including dynamic mouse pointer changes. I will show you how to track source and destination list boxes, move records accordingly, handle minor glitches related to drag and drop, and add an admin tool for fixing control positions. We will also discuss best practices for keeping the mouse pointer and button actions consistent and troubleshooting some quirks users may encounter during operation.

Keywords