Recent content by Georgenetwork

Thanks. Additionally, We only want to calculate workdays between the leavestart and leaveend

Access Help! Here are my fields for the subform Table2 EmployeeID Firstname LastName Date of Birth Table2 ID EmployeeID LeaveType (lookup) Annual Leave, Sick Leave StartDate EndDate Annual Leave limit 20days Sick Leave Limit 10days The leave windows start from january and ends December. The...

Thanks for the effort, but the system is now recognizing everyone who is 18 or above instead of recognizing those who just turn 18. For example if you are born January 1, 1980 it says person is now 18

You are still right, but here is the in catch. The report that will printed on each visit date will have the following Name Date of Birth Gender VisitType - Visit1 or visit2 or visit 3 etc Status -which should indicate that the person is now 18 or null if they are not yet 18 So i think the code...

You are still right, but here is the in catch. The report that will printed on each visit date will have the following Name Date of Birth Gender VisitType - Visit1 or visit2 or visit 3 etc Status -which should indicate that the person is now 18 or null if they are not yet 18 So i think the code...

You are right! I just want to be alerted that the participant is now 18 so he or she can now Signed. I dont have "formSigned" field in my DB. If this person turn 18, I want to be reminded in the Status field which will state "now 18". Remember, there are several visitdates

They are field, not variable. Can you help with the date function based on the logic above? I calculated by year but it's not helping. Participant birthday is December 10, 2001 and visitdate is June 10, 2019 and its say 18, but the person wont sign a legal document because they are not yet 18

Thanks, I calculated by year but it's not helping. Participant birthday is December 10, 2001 and visitdate is June 10, 2019 and its say 18, but the person wont sign a legal document because they are not yet 18

Thank you all so much. It's working perfectly. I humbly appreciate

Private Sub BaselineScheduleDate_BeforeUpdate(Cancel As Integer) Dim pIDWeek As Integer pIDWeek = Weekday(BaselineScheduleDate) If pIDWeek = 1 Or pIDWeek = 7 Or pIDWeek = 6 Then '1=sunday, 6=friday, 7=saturday' Cancel = True 'Set to true to abort update' MsgBox "Participant's scheduled...

Can I give you teamviewer access please. This is urgent

Thank, but still not working and I am finding difficulties. Can i upload my db or can you kindly assist me remotely (teamviewer)? Please, this is urgent

I am looking for a solution. The have female participant coming for rountine therapy. The participant are visiting 12 times in 3 years. I want a code to tell me on which visit the participant will turn 18 years old. Here are some idea i tried putting together. I am only concern about that visit...

I have a code to disallow more than 3 people from being scheduled on any given date. It's working find whenever you scheduling, but when you reach the schedule limit, it throw an error. Someone please help. I have attached copies of the error

Thank you, it's working for only CounselingDate1. I was the count or limit apply to both counselingDate1 and CounselingDate2. Let it treat it as the same count. Someone can be scheduled for the June 1, 2019 in CounselingDate1 while another person can be scheduled for CounselingDate2 on the same...