Sample data · this browser only

Tasks

Canonical tblTasks with optional tblProjects. Status and priority combos store IDs. Open matches qselTasksOpen. Mark Complete updates the row by TaskID.

What this demo shows · Lab VBA page: TaskList · Demos

Open tasks (Split · datasheet)

Click a row to load the selected record. Open = Active and status not Completed or Cancelled.

ID Title Project Status Due

Task

Lookups store the ID and show the name. Project may be blank.

What this demo shows

The canonical Access Tasks template in the browser: optional project, status and priority lookups, and Mark Complete by primary key.

  • Split list and detail — click a row, edit the current record.
  • Combo stores the ID — project, status, and priority save IDs and show names. Project may be blank.
  • Open filter — Active and not Completed or Cancelled, like qselTasksOpen.
  • Mark Complete — sets status Completed, 100 percent, and CompletedDate to today (this browser only). The row leaves the open list; All still shows it.
  • 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. The same field names (Title, StatusID, ProjectID) are what a company database would store. AssignedTo is a name string, not a Contacts foreign key.

Sample data only. Source: Microsoft Access Tasks template. The TaskList page is the older lab VBA sample, not this table shape.