I need suggestins/ideas for this project?

[Lyla]

Hi everybody..

I'm looking for the best way in doing a daily attendance log. It's 3X8 shift system.
Should i use checkboxes? How about late-coming people?

In general, any comments/suggestions/pointers are really appreciated.

Thnax.

what is a 3x8 system?

------------------
Wossname,
Email me: [email protected]

[Lyla]

Thanx for replying.

That's right 3 Shifts/8 Hours each.

See, my problem is:

This sheet is going to be filled by someone. So, There's no problem with someone signing-in for somebody else.
What I'm looking for is, what is the best method of displying 20,50, OR even 100 staff and then selecting Present OR Absent OR Onleave OR Sick OR OnAssignment OR Late !
How do I deal with the late issue? There is computation!

I'm not asking for code! I'm asking for a design idea only?

Thanx.

[Bob Baddeley]

Three shifts a day, eight hours each shift, I think.

How about two textboxes? One with name another with userid so other people can't check them in. Then those go into a table that has the name and time they logged in. every day or shift you could make a new table or start a new section of the table.

[Bob Baddeley]

have you considered using Access? That might be the tool you want. I haven't dealt with it much because I'm only 17.

Actually, I think it is what you want. The same thing can be done in VB, though. Picture this:

One textbox for the name.
A radio button with each of the options, like Present, On Leave, Sick, and an extra one with Other.
Late and Other both have textboxed next to them. When Late is clicked, the textbox next to it displays current time and the user can change it if they have to. This would be the time they showed up. Later, you subtract the time they were supposed to get there. On Other, I don't know.
When you click OK at the bottom, it adds a whole new set to the database you have included. Perhaps you could then make a new form that lists all the items in the database at once on a table.

I don't know if this is any help, but I'm trying.

post if you need more...

bob

[Lyla]

Thanx Bob..

By the way, I'm using access.

OK. So when we have let say, 70 names in the first shift then we would load all of them on a label arry(since they are read only). Then make a floating frame that has the radio buttons AND a textbox that would be activated if late radio button is chosen.
How about the Table's field Type? should it be Char or time or general for futur analysis/computations.

Any more Ideas...

Thanx.

[s.mahdi]

regarding absent people it should depend on the the pc time and date and it your project should record all the people who exceed ex.7:00 time ,so at the time of evaluation will display the date and the time of the person who was absent.

regards

[ramdasv]

This is a good design issue?
If you have not yet designed
I have two ideas to go ahead with that.
But I think more idea of the system is needed to make a perfect design

Design 1
Have a grid(MSHFlex grid) which can include combo and option buttons inside for selection there presence/options and text box for time of entry.
Each line in the grid for each user of the system.
Design 2
Having a Combo which lists all the users and on selecting the item from the combo the option boxes and and other controls can be associated for the particular user.

Try this design. If you can specify more detail about your problem the design can be improved.
What about the table design?