Recent content by wolfspecter13

I added an unbound control in the footer of the form, LoadRosterActivityID. I changed the value for ActivityID in the query to ActivityID: [Forms]![frmSelectRosterByActivityVer2]![LoadRosterActID] Saved it, closed. The form opens with every kid in the roster file showing, all courses, and I...

I am a VBA neophyte but already have one form - based on a student name-and-ID table (not a query) running fine. Access 2010, Windows 7. I created a new form, very similar in format, but based on a simple query that allows me to input the course # (###) when the form loads. Works great, just...

Thx, spikepl - I do actually design/print scannable paper forms but the client declined this option. There is a need to monitor adherence to completing the forms, which translates into "under teacher supervision", and we are in an extremely rural area without access to the hardware you mention...

Introducing myself - statistician and research analyst since the 1970s - I use Access, Excel, etc., as power tools to manage and maintain data for various projects. Most of all I use Access for data entry and maintenance, large numbers of subjects (individuals), longitudinal (repeated) responses...

I am designing a little database to hold physical activity log info for 2 school districts, required by a grant. Four-five times each year every kid (2000) will complete a log form for 3 days that lists separately for 34 intervals (1/2 hour each, from 7am - midnight) in which physical activity...