record time based on option using textbox

[stoey]

hi there,



I am new to programming access and I need some learning from the experts to start with. I am creating a very simple break tracking program which will record the time INs and OUTs of an employee based on the option entered. This is how my program should work. User enters employee ID. If ID has match, append record. User then enters an option from 1 to 3.... 1 -Break1, 2 -Break2, 3 -Break3. If user enters 1 in the option area for the FIRST TIME, Break1IN would be recorded. If user enters 1 for the SECOND TIME, Break1OUT would be recorded. Break1TOTAL from the table is the total break time consumed say if the employee's Break1 is 07:00 PM and Break1 is 07:30 PM then Break1TOTAL should display 00:30 minutes. I know this sound complicated but basically this is just about record appending and time recording. I hope someone can help me as I was advised that this is the only forum where responsive experts are to be found. Thanks in advance. File attached is the sample program I am in need of help.

Regards, stoey

[stoey]

is there any help i can get here related to my problem? I hope somebody will notice...

[orange]

I looked at your database. This is not the structure you need.
I'm sure you could force it to work, but when you have fields like Break1 and break2...
you are heading for problems. Getting you table structures and relationships set up is key to making your "system" run smoothly.

Do a little googling/reading on Normalization.

Here are a couple of links that you may find helpful.

The first 3 topics here should get you started.
http://www.rogersaccesslibrary.com/forum/topic238.html

Good reference for best practices and tips.
http://www.accessmvp.com/strive4peace/

Here is a model for Employee Leave Recording/Reporting. I know it is much broader in scope than your program,
but it may help show how the "pieces" fit together.
http://www.databaseanswers.org/data_...ping/index.htm

Good luck.