Create a Time Clock Form in Microsoft Access. Clock In and Out using Buttons, Prevent Manual Entry

[@tammym9522]

LOVE THIS!! How can it be set up to have 20 employees sign in and out throughout the day on one main computer?

[@aneeshakm3508]

I am trying to add the code as per your video but it is giving an error that declare variable . Can you please let me know what should be done

[@lozanos55]

Thank you, I followed this exactly and I love it. Just what I was looking for. I have a question about the TimeClockT. While I leave Access open to continually time in and out, it does not save each time in and out. It overwrites the timeclockid for the day. How do I get it to save for breaks throughout the day? I noticed if I close Access it will create a new timeClockID which is what I'm looking for. What did I miss? I use MS Access through MS Office 365. thanks

[@599CD]

Make sure you go to a new record

[@stellakuisseu8220]

thanks for the video. I want to know if it is possible to calculate absences while using this method. if yes how does it works?

[@599CD]

599cd.com/tips/access/student-attendance-append-query/

[@kirangoswami5730]

Is there a way to create something like this in excell? MS access is really hard to get a hold of now

[@599CD]

599cd.com/Ask - and Access isn't hard to get hold of. It's part of the MS 365 for Business which costs like $8 / mo.

[@charlessorman2704]

Hey I've done everything and followed this video but when I clicked the buttons the Time In section just stays blank. The cursor just disappears and I've redone this countless times and ended up with the same result. I need help please

[@599CD]

Without seeing your database, it's impossible for me to tell what you've done wrong. Try again, from the beginning, in a new blank database (or with my free template) and don't skip any steps.

[@vanessmensah4166]

@@599CD I think I'm facing a similar issue Access 2019. The Clock time table doesn't record the times as well

[@pavelzaytsev_moscow]

Richard Super Teacher in Access! Thanks 🙏 Be happy

[@599CD]

Don't worry...

[@anujwadhwa2853]

Wonderful video. Went exactly as per that and it worked marvellously. However, my issue is that it runs on one PC and the same file, when copied on another PC, doesn't work. To explain, Clock In and Clock Out buttons when pressed, do not result in display of any data in the Time In and Time Out Fields on the Form

[@599CD]

599cd.com/ask

[@vwv5555]

I have learned a lot from you. Thanks!!

[@599CD]

Glad to hear it!

[@aidanadiahzaidi6858]

Hi, I want to watch the video on how to generate the ERD after we put all the details. This my task for my assignment. Please help me.

[@599CD]

Good luck with your assignment.

[@wglastonbury3]

Hi, I have followed this method but the only problem I have is how do I actually let my employees use this pop up window?? Thanks

[@599CD]

I don't quite understand what you mean, Woody.

[@smackdown9825]

Excellent information here, thank you!

[@599CD]

Glad you enjoyed it!

[@mercuryptapb]

really enjoyed, thanks alot

[@599CD]

Glad to hear it!

[@mandomartinez9233]

I can not join I keep trying not sure says something about releasing my hold? When I follow the link it takes me to a google screen that says i nee dto download the pay app. what is that?

[@599CD]

You've got me.

[@BanditFX7]

you master your subject well - great

[@599CD]

Thanks

[@Hatakeutd]

How do I make a report that shows the employee names instead of Id

[@599CD]

You bring the employee name into the query, and then the report

[@kjohnson19615068]

Suppose you have more then one employee you can't just leave it open, you need to add record then clear for the next guy,

[@599CD]

Sure. You can do whatever you like. That's the beauty of building your own database with Access. My goal with this video was to show you the time portion. Obviously you'll want to embellish.

[@akterhossain9548]

Time in 6 pm 01.01.2020 time out 2 am 02.01.2020 what is the formula for this? Life saving help pls

[@599CD]

That's basically just two date/time values without times, so those dates at midnight. The video should work fine for you.

[@andresnaranjo8567]

One button works even though I copied it and added the code for the other one it won't record the time

[@599CD]

Bummer

[@lailajess4972]

nice. tnx.

[@599CD]

Most welcome

[@lailajess4972]

@@599CD Tnx. You are a great. I have been thinking long time. I have been using 10 windows.. So I can't. Not easy way. 7 windows I can . Again thanks.

[@ch_rlieb03]

🐐

[@599CD]

Moo

[@richlaw5136]

im getting runtime error '438' object doesn't support this property or method ??? Option Compare Database Option Explicit Private Sub StartTime_Click() StartTime = Now() Me.Refresh End Sub Private Sub EndTime_Click() EndTime = Now() Me.Refresh End Sub