Member Avatar for danish_k12

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
  • 195 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by kinwang2009
Member Avatar for debasisdas

what about using flexgrid ? or any other grid control.

Member Avatar for danish_k12

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.

Member Avatar for ithelp

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.

Member Avatar for compph

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

Member Avatar for kinwang2009

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.