Sample data · this browser only

Events

Canonical tblEvents / frmEventList (Split). Fields: EventID, EventName, StartAt, EndAt, Location, Description, Active. No people table. Data lives in this browser only.

Upcoming = Active and (EndAt empty or EndAt on/after today) · What this demo shows · Issues · Demos

Upcoming events (Split · datasheet)

Click a row to load the selected record. Upcoming matches qselEventsUpcoming.

ID EventName StartAt Location

Event

Name required. EndAt must be on or after StartAt. Mark Done sets Active = No.

What this demo shows

A Microsoft Access events diary in the browser. One table, no unused sales spine.

  • Split form — upcoming (or all) events and the selected record.
  • Validation — EventName required; EndAt on or after StartAt.
  • Mark Done — Active = No by EventID.
  • 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. Sample rows live in this browser today. The same field names (EventName, StartAt, EndAt) are what a company database would store.

Sample data only. Source: Microsoft Access Events template.