Access → Web lab · Canonical Issues
Issues
Browser recreation of DataWeb Forge Issues.accdb —
tblIssues plus three lookup tables, Split Form
(frmIssueList DefaultView 5), and
qselIssuesOpen. Combos bind the ID and show the name.
Click a row to load the selected record — same idea as Access Split Form.
Open = Active and status not Resolved or Closed (qselIssuesOpen).
| ID | Title | Status | Pri | Due |
|---|
frmIssue
Combos: option value = lookup ID, text = name. Same as Access cbo.
Access → web mapping
| Access | This page |
|---|---|
DefaultView = 5 Split |
List pane + selected-record form (same layout as TaskList, richer data) |
tlkpIssueStatus / Category / Priority |
Combos: <option value="ID"> shows the name |
qselIssuesOpen |
Open filter — Resolved / Closed / inactive drop off |
btnMarkResolved |
UPDATE StatusID to Resolved (not a checkbox) |
Form_BeforeUpdate |
Save blocked if Title blank |
frmIssue still has no cbo |
This demo invents the combos from the lookup tables — next Access increment |
| Tab control (two pages) | Issue: title, combos, assigned, active. Notes: opened, due, description, comments. Buttons stay outside the tab. |
Access source UNC:
C:\AI\GROK_Build\dataweb-forge\templates\canonical\issues\Issues.accdb