Recent content by m-taha

everyone uses it, they all register their hours and they all have it installed on their pc as a remote desktop connection. there is a username, i am still searching where i can find this information in the database. it is a training 😁 my coworker always tells me to just try any idea that comes...

yes all employees use this program, i have thought about testing the user yesterday but i actually don't know where to find the users 😅. my coworker assigned this task to me for my training but i don't know where to go from here, i'm not sure how the entire system works either!

so after checking all the employees, what am i supposed to do to determine that yes indeed this employee is a temp and he should be restricted, and to have the program actually enter the if statement not just ignore it ?

yes, to be able to see the whether the selected employee a temp is or not

because the field is boolean, yes temp no not temp , and if i select based on this criteria, wouldn't it just select everyone ?

btw what's your understanding of PersPlan_Temporaere ??

aaah yesss of course, obviously i've lost my senses.. Thankyou so much

OMG i just saw what what you meant, man i'm such an idiot 🤦‍♀️ok then how about if i did this ?

the development form i have u can choose the employees, but in the productive form ie. if i open mine (without logging) i find my name already selected and i can tap in my hours right away, that's why i thought to write the program in Form Load()

yes that's true

It's because the names and ID numbers are in the employee table but the Is_A_Temp information and hire and termination dates are in the employee hours table the two tables are connected with the id number (PersNr) i could use a dlookup and use it as a variable , right??

I have a form where employees register their daily work hours. I am trying to put a restriction on Temprary employees that since they work hourly wages they can't register hours as non-performance such as ( public holiday, vacations, sick leave or military duty, minus hours... etc). The...

Thank you I really appreciate it 😇

Your suggestion worked like magic, it even updates the code :love: thank you so much it's because i don't know much about vba, the syntaxes and all that still haven't got the hang of it

thank youu, bust don't think my coworker would be too thrilled to add another field table t link it from, tried once 😅 , "just save it on the pc drive and delete it later so we don't waste anymore space"