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 the selected task. Priority: High · Medium · Low.
| ID | Title | Due | Pri | Done |
|---|
frmTasks
Buttons map 1:1 to Access command buttons and VBA handlers (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 the Title field |
btnSave_Click |
Persist row to localStorage; refresh caption |
btnDelete_Click |
Confirm then delete; refresh caption |
btnMarkComplete_Click |
Set IsComplete = true and save |
What this demo shows
The Access TaskList sample in the browser: the same New, Save, Delete, and Mark Complete buttons, plus Title required on save.
- Form_Load caption — the heading shows how many tasks, like Access
Me.Caption. - BeforeUpdate — a blank Title blocks the save (no illegal SetFocus).
- Unsaved changes — leave a dirty record and you get Yes / No / Cancel (Access
Me.Dirty).
Will this work when the data is in a database?
Yes. This page uses sample rows in this browser. Yes saves first, then moves; if a later company database save failed you would stay on the record.
Sample data only. Not a live production system.