Access → Web lab · VBA
Tasks
Browser recreation of TaskList_Demo.accdb —
table Tasks, form frmTasks, and the same
VBA event logic (Form_Load caption, BeforeUpdate Title validation,
New / Save / Delete / Mark Complete).
Click a row to load frmTasks-style bound form. Priority: 1 High · 2 Medium · 3 Low.
| ID | Title | Due | Pri | Done |
|---|
frmTasks
Buttons map 1:1 to Access command buttons and VBA handlers (DEC-028: no illegal SetFocus).
VBA → web mapping
| Access VBA | Web behaviour |
|---|---|
Form_Load |
Page caption / heading: Tasks (N total) |
Form_BeforeUpdate |
Save blocked if Title blank — no focus call (illegal in BeforeUpdate) |
btnNew_Click |
Clear form for new row; focus Title control (txtTitle) |
btnSave_Click |
Persist row to localStorage; refresh caption |
btnDelete_Click |
Confirm then delete; refresh caption |
btnMarkComplete_Click |
Set IsComplete = true and save |
Access source UNC:
…\laboratory\phase1-tasklist\output\TaskList_Demo.accdb