Recent content by AsMok

great suggestion.... many thanks 🙏

Many thanks for your quick accurate reply 🙏 It works now (y) If SN.Value = **** And Me.PASSWORD = DLookup("[PASSWORD]", "USERS", "[NAME]='" & Me.Des & "' AND [activation] = True") Then

Hi all i have this part of login code. . . If SN.Value = ********** And Me.PASSWORD = DLookup("[PASSWORD]", "USERS", "[NAME]='" & Me.Des & "'") Then Me.Visible = False DoCmd.OpenForm "**********", acNormal . . It works great But now I need to add yes/no field as a criteria ( I did it as the...

HI.... The photo I attached to my last reply gave me an idea... since the problem is in the table field... I should work on it... I formatted the two table fields this way "09"@@@@@@@@ "091"@@@@@@@ and then suddenly the problem solved ^_^ hope that is ok???

done

ا hi theDBguy..... sadly nothing changed.... It still storing the same way.......

hi all :) I have this input masks for two phone numbers fields.... !"09"0\-000\-0000;;_ !"091-"000\-0000;;_ They work great on the form BUT it dose not store the first part of the area code 09 in the first field AND the whole area code 091 in the second one.... I want them to be stored...

IT seems up to now things is ok ....... I just changed >>>> (!ItemStatus = IIf(!check, "AB", "CD")) to this>>> (!ItemStatus = IIf(!check, "CD", "AB")).. to get the exact change I want... I reviewed the changes in my table and it is exactly what I want.... I will work on it more to see if...

Many thanks I will try your code now and see the result.... BTW..my office and data is Arabic.... should I change the version?????

HI theDBguy ....nice to contact you again.... to make things clearer I should write my steps to show data and what i want to achieve..... 1. choose zone from drop down list... 2. choose driver name 3. then click done button to change and fill the records (status and driver name) that have...

hi all NICE to contact you again I need help how to make "DONE button" in my continuous form work for all fields not the first active field only !!! thanks in advance

Hi all Thanks all I placed Iif function on my report and finally I got it as I want ......for sure I will take other work conditions in mind.... if you expect any future problems please notify me --- i placed this function to unbound text...

i just wrote it in general to know how can i sum it.... job conditions are more accurate and count it by days and hours it is just a mock case

hi all lets assume that we have 2 employees ::: according to job conditions -------employees have 30 days as an annual leave if the work for the company less than 3 years -------------and have 45 days as an annual leave if the work for the company more than 3 years calculating this year leave...

DONE any suggestions :cool: