Recent content by jocelyn_ooi

YES.. i include the state data on table holidays as well. But i dunno how to coding to count the days according to state.

i have create a table holidays and written code on module... the following is my code. ublic Function Work_Days(BegDate As Variant, EndDate As Variant) As Integer ' Note that this function does account for holidays. Dim WholeWeeks As Variant Dim DateCnt As Variant Dim EndDays As...

Hi there, i already success to exclude public holiday when user apply for annual leave. But now i have 1 problem is if user work on different state so they will have different holiday. So, can anyone suggest a method to solve this problem??

hi there, i have create a pivot chart for showing retention rate per years. How i insert retention formula to calculate the value on data area ?? HELP!!!

how to validate the acceptable path? i not so familiar in ms access..

i wanna create a browse file function in my access and i success run the system by following code. But i want let user only can select the file from specific path/location for example in c drives anyone can help me to do so? Private Sub cmdBrowse_Click() ' Requires reference to Microsoft Office...

hi there... i want the system able to calculate the end date by given month.. for example, the start date is 12/09/2011 , after i set the month is 5 means the system will automatic calculate the end date 12/02/2012... izit possible to do it?? thx~~

StrLeaveSql = "SELECT * FROM tblLeave WHERE emp_id = '" & rstReplacement!emp_id & "'" & _ " AND lea_leave_type = '" & Me.txt_leave_type & "'" & _ " AND lea_effective_date = '" & rstReplacement!lea_effective_date & "'" & _...

how to do the pop out message when user log in?? IN my case, if there have pending leave require to approve the message box will pop out once user log in the system... but i dunno how write the code to link the pending leave data in the table with the pop put message?Anyone can help?

hi there...i want to write a code by automatic write off the brought forward leave when the brought forward date is already expired... anyone gt any idea can teach me? Me.txt_leave_entitled = Nz(DLookup("lea_bf", "tblLeave", strEmpLink)) Me.txt_bf_leave = Nz(DLookup("lea_bf_exp_date"...

ok...I want to set the date for apply leave. When I apply leave for example start date is 12-09-2011 and end date is 17-09-2011. After that I try apply a leave on 15-09-2011. So the system should pop out "You have already applied this leave before!" since 15-09-2011 already applied before... It...

i am thinking that if i change the place "AND ((#" & Me.txt_start_date & "# " & _ "BETWEEN [tkl_start_date] AND [tkl_end_date]) " & _ "OR (#" & Me.txt_end_date & "# " & _ "BETWEEN [tkl_start_date] AND [tkl_end_date]) " & _ izit will affect the operation i wan to run? cuz got involve "BETWEEN"

criteria = "[emp_id] = " & Me.emp_id & _ "AND ((#" & Me.txt_start_date & "# " & _ "BETWEEN [tkl_start_date] AND [tkl_end_date]) " & _ "OR (#" & Me.txt_end_date & "# " & _ "BETWEEN [tkl_start_date] AND [tkl_end_date]) " & _...

criteria = Me.txt_emp_id & " = [emp_id] " _ & "AND ((#" & Me.txt_start_date & "# " _ & "BETWEEN [tkl_start_date] AND [tkl_end_date]) " _ & "OR (#" & Me.txt_end_date & "# " _ & "BETWEEN [tkl_start_date] AND [tkl_end_date]) " _...

hei there... wanna ask for help... i want to set the date for apply leave. the following is my code. There have 1 problem when i apply leave for example start date is 12-09-2011 and end date is 17-09-2011. After that i try apply a new leave on 15-09-2011. Suppose the system should pop out "You...