Search results

Its not like workload, But it is moneyload, ha ha ha A worker visa renewal most money. some month is over the budget for renewal Resident CARD. And some month is NULL. We need it to do by average calculation to get each month is same quantity. We have Visa or Resident CARD expire date. And...

if you're make average of dates by condition method of renewal that I explain (3m / 6m / 9m ) then quantity will average came.

I explain it here a months. EmployeeID Expire Date Renewal Method You can renewal 3 Months Or You can renewal 6 Months Or You can renewal 9 Months JAN 1325 06/01/2023 06/03/2023 06/06/2023 06/09/2023 891 09/01/2023 1034 10/01/2023 1272 11/01/2023...

Thanks for your comment. JAN TO DEC is starting date 01 to end of the month total quantity we have 1297. MONTH NAME TOTAL QUANTITY EXPIRE DATE WE LOOKING JAN 0 [starting date 01/01/2023] to [31/01/2023 end of the month] TOTAL EMPLOYEE / 12 MONTHS FEB 258 [starting date 01/02/2023] to...

We have 1297+ foreigner workers who is work with us as work resident permit (WRP) . We called this resident permit card "IQAMA". Iqama have valid date and it is can renew by 3 Months / 6 Months / 9 month and 12 month (1yr) upto 3 yrs . We facing a problem that some month we have 250+ Iqama's...

Form frmEmployeeEdit under the TAB Control page in subform "sfrmContract" Yeah, in subform ContractType field have droplist. But not lookup in the table tblContracts.

Yes, Each employee have multiple contract. That why, I want to condition if tblContract.EmployeeID is present then Ignored to append. Yeah, DateEnd filed is set Date/Time.

Hello everyone ! I have a table "tblEmployee". it is INNER JOIN with table "tblContracts" by EmployeeID. I would like when I enter the employmentDATE then it insert date into the table tblContracts in DATEFROM field. also appending this same EmployeeID within others 4 fields LIKE ...

Great !. Its work now. Appreciate & thanks one more for giving your valuable times.

Thanks again. It was given result as SAME only ONE side. If I enter the DateLeft then RESULT given, otherwise blank field. Here need two result, Still work and Left work.

Thanks for your reply. here is not working... Somehwhere giving wrong calculate. Example the [EmployeeID=5] And if employee still work then there only display "He served in Company"

Thanks your replay I using it on Form and Report.

I dont know why here not work. Oh, get it... It is work now if replace ">0" to "<0" Thank you very much Madam @June7 One more question. If any employee STILL work then how to calculate with same field in expression. example : Still work ="He served in Company " & IIf([EmploymentDate] Is Null...

Now does not have any error in expression, but not give result. return blank filed.

Here I using the module of Original Developer: Michael Walsh Calling: Call from Control Source of Text Box Func : =IIf([BirthDate] Is Null,"",CalcAge([Birthdate],Date())) It is work good. But problem is when employee is left then it is not calculated DateLeft IIf([EmploymentDate] Is...

I have total 8 sub-folder under of EMPLOYEE FOLDER. now here I added ONE more folder for VEHICLE LICENSE. EACH folder MANAGED add picture or pdf file by EMPLOYEE ID. in DOCUMENT is various file download from database pdf or word or excel. Example : Report for Vacation or Absent : its arranged...

need a little help.. my some file format is " .png and .jpeg " And VBA there can added ONLY ONE. How can I added multi EXTENSION for image in same a line.

Thank you @CJ_London & @moke123 . Its work now. :) Its problem with my pdf READER, when I re-installed and Installed new version then form displayed pdf file .

You maybe not get my explanation. my path is displayed in the textbox as like : "E:\TEST LOCATION\EMPLOYEE FOLDER\PASSPORT\1630.pdf " But the problem is not displayed in the Form within " WebBrowser1".

Yes Yes, fields name is "WebBrowser1"