View Full Version : Solved: Help needed with sign in register
Paul C
07-04-2006, 01:54 AM
Hi I am designing a sign in register for work, i need to have a button which will input the current time into the register when pushed, I also need a date button, the idea being when someone signs in they input there name, then simple press the time-in button and date button, any ideas on how this can be done?
I have attached a sign in register fto give you a idea, but need the time in , time out and date buttons added.
Thanks for any help, its very much appreciated.
Paul
Just an idea. I had problem with the today function but it works.
Paul C
07-04-2006, 05:22 AM
Just an idea. I had problem with the today function but it works.
Hi ALe, Thankyou for replying, it works great but i need the time out button to put the time out in the specific row i highlight, anyone know of a way of doing this.?
Sorry to be such a pain.
Paul
Private Sub CommandButton3_Click()
Cells((ActiveCell.Row), 13).Value = Hour(Now) & ":" & Minute(Now)
End Sub
Paul C
07-04-2006, 06:32 AM
Private Sub CommandButton3_Click()
Cells((ActiveCell.Row), 13).Value = Hour(Now) & ":" & Minute(Now)
End Sub
Thanks a lot ALe its much appreciated
Best Regards
Paul
Paul, don't forget to mark this thread as solved
Paul C
07-04-2006, 12:04 PM
ignore :)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.