Timesheet Manager

[bjsteyn]

At the moment at the company I work for every month timesheets have to filled in and signed by you and your supervisor and is sent to our Accountant.At the moment the timesheets or done in excel by the employees and sent to our accountant.

I have come up with the idea which will speed the process up. I want to create a db where you can login and enter your timesheets and our accountant can have the info at his disposal at any time.

The thing is it needs to be signed. Digital signutere is thus the answer. Can anybody give ideas on how to create a digital signutere for each employee.

 

[alfi]

It depends what you are trying to achieve, if you are trying to validate a user then a username and password should be enough. a more strongly validation will be to make sure that the user is logged in on his machine, this can be done by verifying the user with the windows login username through the Environ("username") method.
If you have a dedicated machine for logging in so again send the machine Environ(“username”).
Another way is to send email form the user outlook ....
It is all depends of how you define an electronic signature. You can also invest in fingerprints scanner (even though I think it is an overkill in your scenario).

 

[bjsteyn]

Sorry

What I meant is that the employee has to sign the timesheet and his supervisor also has to sign the time sheet for it to be processed.

Normally the employee would print it in excel and sign it and then give it to his supervisor to sign.

Any idee how can animate this in access.

 

[alfi]

In that case my suggestion will be either to change the way login is done or to scan and attached the supervisor scanned confirmation.
Another approach will be to provide the supervisor another way of confirming the user input . the user for example can send his timesheet as an attachment to the supervisor and then the supervisor will add an electronic signature to the email (you can predefine electronic signature to emails so the supervisor only needs to replay in order to confirm). It seems to me that the problem is not of access implementation; rather of transforming the current manually process into automated process.

have a good one
alfi

 

[bjsteyn]

Somebody told me that I could use a fingerprint scanner but that is going into a budget I dont have. At the momemt I want to create a working demo I can purpose to management to get go ahead on. How do you create a digital signiture and cant it be copied easily.

Thanks
bj