Solved

how to get attendance of several kids faster - VB6

Posted on 2014-01-06
1
293 Views
Last Modified: 2014-01-06
I have a vb6 form.  The following are entries for logging the one student at a time:

Name - Dropdown List populated from DB table
Hours - Enter value
Date - Enter value
Activity - Dropdown List populated from DB table

It can get tedious to do 200 kids sometimes with several days in the month to log.  Is there a faster way to see all the students and enter the hours/date/activity for each student?
0
Comment
Question by:al4629740
1 Comment
 
LVL 25

Accepted Solution

by:
SStory earned 500 total points
ID: 39759845
Well there are control arrays where you could list all 200, but I don't see where that would help.  You could have it start with student 1 (non selectable), and when they hit enter on the last option or choose it they go to the next student or have a next prev button.
As for the date once when they start if all are the same and default that box to the date given.  If all activities are the same for given entries at a time, ask what the activity was and default to that each time to save the user time. Do the same for the hours.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question