Prompt early log out time using msgbox

hi,

i have an excel file which tracks break time. The program works by logging in the start time of break and the log out time of the break of every employee. What I would like to do is to have a prompt if the user immediately logs out at an early time. Say if the user's start time break is 1:00 PM, if he happens to log out immediately, he should be given a prompt that he can only log out after 25 of his total 30 minute breaktime. Thus he can only log out at 1:26 PM.

My code below currently logs in and logs out the time but without the prompt i would like to have.

Please Login or Register  to view this content.

thanks,

stoey

Can you post an example copy of your workbook - it will make it easier to workout what needs to be changed/added/removed from your code

hi,

here's a sample workbook requested. this workbook currently works by logging in and logging out the break time of a user. I would like to make a msgbox displayed if the user tries to log out immediately...Like if the user logs in at 1:00Pm then when he tries to log out immediately, a msg prompt would appear saying that " You can only log out starting at 1:25 PM which is 25 minutes after, of your total 30 minute break time." After 25 minutes then he can start logging out so as not to be overbreak on his 30 minute allowable break time.

Thanks,

Stoey

I hope I have fully understood your problem
On a backup copy of your workbook try replacing your Private Sub cmdendb1_Click macro with this one

Also I notice that you have no error checking for when an ID is not found or when trying to Add Start time - I have added error checking to the code below to ensure that the variable CurRow has a value in it greated than 1

Please Login or Register  to view this content.

glad to hear the code I provided solved your problem