473,327 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Horizontal Continuous Forms

Hi

I am making a Student database, which includes an attendance register.

I would like to set the input form up to resemble how a normal paper-based register would look (for ease of use).

Name Week1 Week2 Week3...

All the names will be in first column and then in each column after will be a combo box with a list of mark codes for present, absent, holiday, sick etc.

Each course has a different number of sessions and each student will have a mark for EVERY session.

Is there a better way I can go about this or is it possible to make a continuous form repeat across rather than down?

Regards
Scott
Mar 12 '08 #1
2 3747
Stewart Ross
2,545 Expert Mod 2GB
...I am making a Student database, which includes an attendance register.
I would like to set the input form up to resemble how a normal paper-based register would look (for ease of use).

Name Week1 Week2 Week3...
...
Hi. It is not really practicable to mimic the paper attendance register in the way you describe. You would find it very difficult to prepare a generic data entry form which could accurately reflect the relationships between the underlying data, and the potential range of start and end times for each class. You need to consider how practicable it would be to set up any kind of form that involved so many direct and indirect relationships (such as academic year, course, course year, year group, subject, subject week, room, tutor, student, and time period).

Commercial systems print attendance registers in a standard grid-based format for lecturers to complete - but they don't try to mimic this approach for data entry. Attendance is simply entered one week at a time.

The cleverest approach to student attendance recording I've seen is in one major commercial system in use in the UK where users only need to enter absences or lateness. Attendance is taken as a default, as for most classes the majority of students do attend. In the best case, when there are no absences to record, the data entry operator simply presses one button to confirm that all students attended and the class register instance is updated accordingly.

By the way, continuous forms do not repeat horizontally.

Hope this gives you some ideas for ways forward.

-Stewart
Mar 12 '08 #2
Stewert,

Thank you for your reply.

Bit of a shame I cannot do it that way. Never mind though, I have another method up my sleeve.

Regards
Scott
Mar 12 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Armando | last post by:
I recently saw the tail end of a "Continuous forms" discussion, but not enough was available to see if this will be a PITA repeat question. Sorry if it is. On a form with its Default View...
3
by: Richard Hollenbeck | last post by:
I have the following query in my form's code: Private Function Get_Data(fieldNum As Integer) Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset strSQL = "SELECT & "", "" & ...
2
by: Sam | last post by:
I've researched and tried all the suggestions I've found and still haven't been able to get the horizontal scroll bar to appear in my combo box. I've tried setting the Column Widths property...
2
by: panwala_bhavesh | last post by:
Thanks in advance... I have a form displaying the results of a query in a continuous form style. I want to be able to double-click on the key field of the form (a textbox, in this case a AssetID)...
5
by: Michael R | last post by:
Searching the net I've found a simple technique to add row numbers and alternate colors (for the even and the uneven row) to a continuous form. 1st step: Create a textbox, send it to background...
1
by: blueheelers | last post by:
I have been researching for several hours on the best way to display images in continous forms in Access 2003. For example, I want to display employee name, email, phone, and picture for each...
1
by: rpboll | last post by:
I am looking for the best way to accomplish the following continuous forms concept. There are Five Groups: A, B, C, D, E Each group has eight Members: a, b, c, d, e, f, g, h Each...
1
by: desktop | last post by:
Is there some function i C++ that prints a horizontal/vertical line in a shell like printHor(2,7); that prints a straight continuous line with the size of 5 chars?
8
by: Steffen Beck | last post by:
Hi NG I need some help with a problem on my forms. If I have 2 related tables, for instance companies and employees, and want to display all companies on a continuous form with their...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.