Richard Super Teacher in Access! Thanks 🙏 Be happy
@599CD
6 ай бұрын
Don't worry...
@aneeshakm3508
2 ай бұрын
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
3 жыл бұрын
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
3 жыл бұрын
Make sure you go to a new record
@BanditFX7
3 жыл бұрын
you master your subject well - great
@599CD
3 жыл бұрын
Thanks
@smackdown9825
3 жыл бұрын
Excellent information here, thank you!
@599CD
3 жыл бұрын
Glad you enjoyed it!
@vwv5555
3 жыл бұрын
I have learned a lot from you. Thanks!!
@599CD
3 жыл бұрын
Glad to hear it!
@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
@mercuryptapb
3 жыл бұрын
really enjoyed, thanks alot
@599CD
3 жыл бұрын
Glad to hear it!
@stellakuisseu8220
2 жыл бұрын
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?
Is there a way to create something like this in excell? MS access is really hard to get a hold of now
@599CD
26 күн бұрын
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
3 жыл бұрын
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
2 жыл бұрын
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
2 жыл бұрын
@@599CD I think I'm facing a similar issue Access 2019. The Clock time table doesn't record the times as well
@aidanadiahzaidi6858
3 жыл бұрын
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
3 жыл бұрын
Good luck with your assignment.
@wglastonbury3
2 жыл бұрын
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
2 жыл бұрын
I don't quite understand what you mean, Woody.
@kjohnson19615068
3 жыл бұрын
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
3 жыл бұрын
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.
@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
@mandomartinez9233
2 жыл бұрын
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
2 жыл бұрын
You've got me.
@andresnaranjo8567
2 жыл бұрын
One button works even though I copied it and added the code for the other one it won't record the time
@599CD
2 жыл бұрын
Bummer
@akterhossain9548
3 жыл бұрын
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
3 жыл бұрын
That's basically just two date/time values without times, so those dates at midnight. The video should work fine for you.
@lailajess4972
3 жыл бұрын
nice. tnx.
@599CD
3 жыл бұрын
Most welcome
@lailajess4972
3 жыл бұрын
@@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
2 жыл бұрын
🐐
@599CD
2 жыл бұрын
Moo
@richlaw5136
5 ай бұрын
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
Пікірлер: 42