Sample data · this browser only

Time card

Canonical tblEmployees / tblWorkHours. Startup is fmnuMain: Employees or Hours. Work code stores CodeID and shows the name.

localStorage · What this demo shows · Ledger · Demos

Click a row. The Hours tab lists only that employee’s rows (LinkMaster/Child = EmployeeID).

ID	First	Last	Job

Employee (frmEmployee · tabEmployee)

First name and last name required. Hours tab is this employee only.

FirstName *

LastName *

JobTitle

Phone

Notes

Active

fsubHours · this EmployeeID

ID	Date	Code	Hours	Description

Open hours (frmHoursList)

Click a row. Filter combo stores EmployeeID. Code combo stores CodeID.

Employee

ID	Last	Date	Code	Hours

All employees 0.00

Selected employee —

Hours

What this demo shows

A Microsoft Access time card in the browser: employees, work codes, hours, and totals that do not shrink when you filter.

Switchboard — fmnuMain: Employees or Hours.
Tabs — General | Hours on the employee, like Access frmEmployee. Hours are that person only.
Combo stores the ID — employee and work code save IDs, show names.
Filter plus totals — pick an employee on the hours list; All employees still sums the whole shop.
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. Totals and filters are form behaviour. Sample rows sit in this browser today; the same DSum idea becomes SQL SUM(Hours) against the company table.

Sample data only. Source: Microsoft Access Time Card template.