0

Hi,
I m making a software which calculates the hours worked by each employee per day. This is calculated by the in time and out time of the employee. I have the database which contains the in time n outtime of the employee in sql.
Now, My problem is i want to show a table in vb6 form where all the days of the months are in columns and one rown in the left contains the emp_code and the rows below the days of the month contains the hours worked by the employee.
eg.
In_out_time emp_code
2008-07-29 12:19:49.000 1
2008-07-31 11:38:32.000 1
2008-07-31 12:34:14.000 1
2008-07-31 20:23:00.000 1
2008-07-31 20:23:11.000 1
2008-07-31 21:06:55.000 1
2008-07-31 22:42:37.000 1
2008-08-01 07:49:33.000 1

This is the sample database from which the max time per day is out time and min time is the in time.
here 1 is the emp_code and 6 5 7 8 are hrs worked on the days 1,2,30,31 respt.

Days 1 2…. 30 31
Empcode/hrs worked
1 6 5…. 7 8

....
and when the user click on hours on the abv eg 6 he should see the in time and out time.
Which controls i should use dont think Crystal report will work as i have to click on hours and the user can change the out time (ofcource authentication require.)

5
Contributors
5
Replies
8
Views
8 Years
Discussion Span
Last Post by kinwang2009
0

I want to use the grid control the problem is i dont know how i can i get all the days of the month as the column and the other attendance details as rows.

0

I want to use the grid control the problem is i dont know how i can i get all the days of the month as the column and the other attendance details as rows.

There must be some calendar object.

0

How can I capture time if the employee logs-in and out? Can you show some codes to do this? thanks

0

Hi compph,
Use Form Load and Unload to capture your Login and Logout time respectively.
Below example might help you how to capture time

Dim strTime As Date
strTime = Format(Time, "HH:MM:SS")

After capturing time you might use Add and Update method to add record to your database.

hope this helps

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.