Employee Time Software

[Guest]

Does anyone know of a simple access program for clocking in employees? They
only need to clock in thier start time. The program does not need to
calculate hours, etc.

If you are not aware of something like this, do you know where I may find
one, or any tips on how to make one?

Thanks.

Bryan Bloom

 

[Guest]

I'm currently working on a fairly complete time system, integrated to other
functionality. This is quite simple to do.

Create a table to store your clock-in data (empname, timein). Create a
form, add a combobox to select the employee name, and put a button on there.
In the OnClick event, of the button, include this statement (or something
similar):

docmd.runsql ("insert into [TableName] (empname, timein) values
([combobox1], time() );")

That should cover what you are asking for. However, be prepared to find you
actually need to capture a little more information. =)

HTH

Sharkbyte

 

[PC Datasheet]

You need two tables:
TblEmployee
EmployeeID
FName
MI
LName
etc

TblWhatever
WhateverID
EmployeeID
StartTime
etc

Note: TblWhatever needs more fields to define what the start time is for.
Presumably they will need to clock in more than once (different days,
different jobs, different projects, or whatever).

Create a query that includes both tables to give you the emplyee full name
andthe StartTime. Build a continuous form with two textboxes based on this
query. The first textbox needs to display the employee name and the second
textbox needs to display the StartTime. Name the second textbox "StartTime".
Disable the StartTime textbox and set its Locked property to Yes. Put the
following code in the Click event of the employee textbox:
Me!StartTime = Now()
When an employee clicks on his name, the current date and time will be
automatically entered in the StartTime textbox.
If you want help setting this up, I can set it up for you for a very
reasonable fee.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1125 users have come to me from the newsgroups requesting help
(e-mail address removed)
Me

 

[StopThisAdvertising]

If you want help setting this up, I can set it up for you for a very
reasonable fee.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1125 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To Steve (or Martin?):
Over 380 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

 

[John Marshall, MVP]

If you want help setting this up, I can set it up for you for a very
reasonable fee.

These newsgroups are for free help! Steve has no interest in helping you, he
is only interested in the money.

John... Visio MVP