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.)

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.

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.

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

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 article has been dead for over six months. Start a new discussion instead.