Search results

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"

thank you, the code generator works pretty well actually, it's just the image placing that's making it frustrating

i do check it every time i run the code and there's always a picture of a qr code with the correct information, i change them up every time to check that's it's working correctly this is the bit where the code generator is supposed to open the report and add the picture to the image control...

thank you for replying 😊 , German is pretty difficult hhh 😅, i should've explained what's going on in that database, even if you see the forms and the tables it looks pretty confusing i still can't my out of it.. but i could screenshot the forms and their queries. (this is just my process) i...

i wish i could, but it's in the company's database server as it doesn't belong to me

i know, right!? there isn't much written anyways it worked at one attempt when i happened to place the order of code line differently but now it doesn't work, i'm literally just putting it randomly to make it happen again (which is stupid i know) 1-i thought of placing it somewhere before the...