Member Avatar for tyronemiranda

Good Day! I would like to ask for any idea on how to record the time log using recordset. Can you please give me some ideas on how to do it?

BTW im using vb 6.0 and access03 for my sources.
my fields are EmployeeNo. EmployeeName. TimeIn. TimeOut. TimeIn(2). TimeOut(2)

For time(2) that include breaktime.

I used DataEnvironment before but i think that's not good enough. So please help me.

Thankyou in advance!!

  • 2 Contributors
  • 1 Reply
  • 119 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by cuzintone
Member Avatar for cuzintone

When I wrote a time clock application many, many moons ago, I used multiple tables in the database and just kept the time stamps.

Basically something along the lines of this:

Employee Table

EmpID Employee PunchStatus

PunchLog
PunchID EmpID PunchTime

Then I would use a query to piece the data back together.

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.