How to Create a DAILY TIME RECORD in MICROSOFT ACCESS | Part 1

How to Create a DAILY TIME RECORD in MICROSOFT ACCESS | Part 1 | Edcelle John Gulfan

Рет қаралды 17,307

Күн бұрын

Пікірлер: 37

@ericjhong.jagunos9698 2 ай бұрын

Hi sir Edciel, I already subscribed your channel. But I have concerned, as I follow your instruction to do the dtr, one thing I notice which is the date, that did not synchronize on the next day, example: 06/16/2024 11:59:59 PM, when it strike on 12:00 MN still the date 06/16/2024 can you have a troubleshoot video for this? Thank you sir❤

@sumonshawon8901 2 жыл бұрын

Nice Video Sir.........Thanks for Upload

@EdcelleJohnGulfan 2 жыл бұрын

Thanks for watching

@hopemosquera7962 2 жыл бұрын

I like this also po sir..

@EdcelleJohnGulfan 2 жыл бұрын

Salamat po. You can download it. There's a link below the description.

@fawzilakian2928 Жыл бұрын

Hi, how po mag add ng 1 hour break in and out as well as coffee break 30mins

@migirooruru2488 Жыл бұрын

HI SIR I FIRST WANT TO THANK YOU FOR A RECOMMENDABLE WORK. MY CONCERN IS. HOW DO I ACTVATE THE SCAN IN THE FORM? THANK YOU

@EdcelleJohnGulfan Жыл бұрын

Thanks for the question. No setup needed. It's automatic. Just plugin your scanner and start scanning.

@migirooruru2488 Жыл бұрын

THANK YOU.@@EdcelleJohnGulfan

@zalandafghan9647 2 жыл бұрын

Am working on a payroll and a little confused about absences of employees. Want to count total absent days from working days and on form load want total absent daya to appear for each employee so to be deducted from total working days to calculate the net salary.. Thanks in advance

@EdcelleJohnGulfan 2 жыл бұрын

You can use dcount function.

@zalandafghan9647 2 жыл бұрын

@@EdcelleJohnGulfan i did but its not working the way i want it. Can't separate the pay period. E.g. pay period August 2022 and so on

@EdcelleJohnGulfan 2 жыл бұрын

You can try this. kzbin.info/www/bejne/gZiahn9naZ6dh5I

@EdcelleJohnGulfan 2 жыл бұрын

kzbin.info/www/bejne/hGKkooilrJljlZI

@jennicadurangogoloran5354 2 жыл бұрын

Hi sir. It is possible to connect that with biometric? If yes.. And how ?

@EdcelleJohnGulfan 2 жыл бұрын

Yes it's possible but i have not tried.

@ashleyarroyo406 10 ай бұрын

Hello sir edcelle, I'm trying to figure out how to do this, but I'm sure I've done it step by step but I'm getting a mistake. I'm a student who needs help, I hope you can help me TIA!

@LemuelNerbieMrLCM Жыл бұрын

Hello Sir Edcel! First, thank you for this video and me interested with MS Access. I followed your instructions step by step however, there are no data displayed on the Form yet data were recorded in the Queries. What should I do?

@EdcelleJohnGulfan Жыл бұрын

Make sure no source code in the text field so that when it proceeds to the record, the details still display. You can download the free sample. Just find the link below the description.

@climfchurchdavao 2 жыл бұрын

Sir more video tutorials

@EdcelleJohnGulfan 2 жыл бұрын

Sure

@NiffirgkcaJ Жыл бұрын

When I add the query as a source to the form, the form becomes blank. :(

@EdcelleJohnGulfan Жыл бұрын

Do not put a source. Make unbound

@NiffirgkcaJ Жыл бұрын

@@EdcelleJohnGulfan oh! But I followed your instructions and it's still the same. :(

@NiffirgkcaJ Жыл бұрын

@@EdcelleJohnGulfan I just followed this at 18:43.

@EdcelleJohnGulfan Жыл бұрын

Check my downloadable template for DTR. you can use it.

@ptzzycool Жыл бұрын

Hi Sir, thank you for this wonderful tutorial. Just a question here; What sort of swiping machine is better to use with such system and how can that be done? Maybe if you can provide a tutorial on this, that would be great indeed as well. Thanks so much.

@EdcelleJohnGulfan Жыл бұрын

You can use the barcode scanner. No need further set up. Just plugin your barcode scanner and start to scan.

@ptzzycool Жыл бұрын

Sir, that sounds great. Then how should I generate the barcodes?@@EdcelleJohnGulfan

@EdcelleJohnGulfan Жыл бұрын

It's another tutorial.