Thats so benefit,but also have a questions :- tell or teach us how to reduce the access file and make setup file like install program so and how the access file run faster or similar like sql server and c# and then finally how to customize all buttons ,text boxes and label all properties to all screens without developer change it from zero to hero ... Regards 👍🙂

@EdcelleJohnGulfan

2 жыл бұрын

We can do it one by one. Wait for my other videos.

Thank you Boss

@EdcelleJohnGulfan

3 ай бұрын

Thank you for watching

@DECStudio_YTOfficialChannel

3 ай бұрын

@@EdcelleJohnGulfan merun kaba fb boss??. If merun ako query sa System?

@EdcelleJohnGulfan

2 ай бұрын

Fb: Ed Perez Matugas Gulfan

Waiting for the next part :). Great videos!

@EdcelleJohnGulfan

2 жыл бұрын

Thanks for watching Andrea.

Great tutorial Sir. I love to see the next part.

@EdcelleJohnGulfan

9 ай бұрын

The next part would be the report of time in and out.

@ptzzycool

9 ай бұрын

Looking forward to seeing that. Thanks.@@EdcelleJohnGulfan

Thanks for tutorial. Could you do more tutorial about being late or leaving early time on record when you key scan? And if you had idea of it please reply more code pls. Big thx again

@EdcelleJohnGulfan

7 ай бұрын

Thanks for your request.

Thanks for your video tutorials, it help me a lot. But I stock on the QRCode scanning (i'm using Aibecy MP2600 scanner). It always stay on the same field and does not clear the content of the textbox. May be you could help me how to incorporate the carriage return or chr13 in the vba code.

@EdcelleJohnGulfan

Жыл бұрын

You have something missing. I will upload the exercise template for the benefits of all.

@mcguias2954

Жыл бұрын

@@EdcelleJohnGulfan thanks for your early reply, looking forward to your template sooner.

Nice Video Sir.........Thanks for Upload 2nd Part .......... But how to create Daily Time Record Report Sir..........

@EdcelleJohnGulfan

2 жыл бұрын

See you to the next episode.

@sumonshawon8901

2 жыл бұрын

@@EdcelleJohnGulfan ok Sir.........Thanks Sir

Could you build daily dairy in access please steve😊

Hi sir, in this example is lunch break ( ex. 12:00pm to 1pm) excluded in the total time rendered?

@EdcelleJohnGulfan

Жыл бұрын

You can set number of hours to be minus in their total render hours. If i have enough time, i will continue that template.

Dear plz tell how to make attendamce report like these column. EmpCode Time In Time Out

@EdcelleJohnGulfan

9 ай бұрын

I'll the part 3 of this video.

To do a physical inventory, will this model work? to know that what I have in the system is physically using a code reader

@EdcelleJohnGulfan

2 жыл бұрын

No. This is a DTR. all you need is inventory system. You can download Northwind database. It's good and free.

@esmeraldaquintero6100

2 жыл бұрын

@@EdcelleJohnGulfan Thanks...I am also doing this tutorial. thanks for going step by step. I'm learning to use access and much less the ihiih programming language.

Great video as always. But how can we prevent employees from logging out before their shift ends Thank you.

@EdcelleJohnGulfan

2 жыл бұрын

Nice question. Video is To be continued. That's why in included the workshift schedule to trace late, undertime and overtime as well. We can add the code in BEFORE UPDATE EVENT which prevent from logging out before the scheduled time out.

@TechWithSally4D

2 жыл бұрын

​@@EdcelleJohnGulfan It can be done in an other way, create timer event, set the time what you want i.e. "2:30:PM", Then, Disable the login button by default or you may use if statement that if time()

@TechWithSally4D

2 жыл бұрын

I have done same in student management system, he was only allowed to open software b/w 10:00 AM and 02:00 PM

@EdcelleJohnGulfan

2 жыл бұрын

Just a simple vba code in ON TIMER EVENT. It's really possible.

@TechWithSally4D

2 жыл бұрын

@@EdcelleJohnGulfan i made one & also uploaded a video on my channel, you may check it if you want

hi mate instead of typing in barcode name can you select name from drop down list and also can you include a "CLEAR" button so the next user cant see the previous user? thanks

@EdcelleJohnGulfan

Жыл бұрын

That's really possible but not ideal for a swiping machine.

@EdcelleJohnGulfan

Жыл бұрын

Thanks for watching Robert.

Please help me with vba code to read fingerprint as attendance input instead of ID. Thanks you for doing great videos

@EdcelleJohnGulfan

2 жыл бұрын

Honestly, i have not tried that one.

@EdcelleJohnGulfan

2 жыл бұрын

If the output data of finger print reader is available like in excel file, we can make it.

@gaadorashid4498

2 жыл бұрын

thank you

@gaadorashid4498

2 жыл бұрын

i wanted to use persona 4500 fingerprint

Hi, dapat po may tuts pano iadd yung lunch break and coffee break kasi pinas tayo almost lahat may ganun at computed

@EdcelleJohnGulfan

Жыл бұрын

Kasama yan sa plano. May part 3 pa sana yan pero less lang views sa part 2 kaya hindi ko nalan ginawa ang part 3.

I want to run automatic an query every month 1st day can you share any vidoo

@EdcelleJohnGulfan

11 ай бұрын

You have to use the On timer event in form property sheet. Or else you can use On load event and use the IF Function.

@n2d2cool

11 ай бұрын

@@EdcelleJohnGulfan on timer for a particular time within a 24 hours

The last rec dlookup says empty please help

@EdcelleJohnGulfan

Жыл бұрын

Have you use the nz function?

enter emp ID but not show name other fields

but ayaw mag load yung picture sir dun sa picturepath naka default pa den. How to fix this po?

@EdcelleJohnGulfan

3 ай бұрын

Dapat naka-unbound ang textbox sa filepath.

Dear John I have downloaded and i ll check it but it is not working as you show in video... pls share final file.

@EdcelleJohnGulfan

Жыл бұрын

Press the compact and repair Database and close the database then open again.

@m.sknowledge7690

Жыл бұрын

@@EdcelleJohnGulfan Thank You So Much now its working fine.... again Thanks Brother.

@EdcelleJohnGulfan

Жыл бұрын

Welcome

@m.sknowledge7690

Жыл бұрын

@@EdcelleJohnGulfan i have question regarding MS Access. Can we search via voice in access? means Voice Convert to Text?

didn't display the entry status.

@EdcelleJohnGulfan

Жыл бұрын

Entry status must be unbound. Do not put a record source.

@jmateovlogs579

Жыл бұрын

@@EdcelleJohnGulfan yes sir i did what you did pero di nagana sakin 😔

@EdcelleJohnGulfan

Жыл бұрын

Pwede mo madownload exercise file. Nasa part 1 ng video. Check mo lang sa description.