How to Set Due Date counting only Working Day

hello welcome back to my excess video tutorial in this video I will show you how to set the task do all make a task do in the next Sunday like in day currently day or in business they can busines this is exclude the weaken or exclude the holiday is not counting I will show you how to do that how I have a task form in here I can seal it but my due date here is I have to manually you know add it on now to manually add it on but in this tutorial I will show you how to update already depend on the did you save my do is do in the next thing day that's for example okay I we add some feel I have the task to table already I need to add down the start date that's a deal we need to start there first before we can put the due date in there we can add like a 10 day to the start date and then program we already put in live in the next thing day next thing business day for you save and close and go back to my past view I can add this this start date in here now I want the function to work after I input the start date and then the duty be on automatic Papa with the Sunday that I put on I can put the number of day it's a number because I did they need this view to add to the start date and then we give me the due date or you can hard call on the code in the sample we put as a the number of the field that you can put on okay in we go to the design view if I don't use information on number of the day I can put the update even procedure on the started to call add dude a function they can create add a due date public or public function and give did start date yesterday num day as India as this because we need the output as a beta as a due date after we add the number of day just theme is t as record same DPS database demo you did as the theme I count as integer we can use the air handle both functionally and go to arrow XE and lets it ball error dot description VP extension with zoom next okay between e we need to put the code on cochlea it is set the DB as equal to Corinne DB and then step st record set equal to BP dot open record set we need to add the holiday table mean because we need to give the due date which is not counting the holidays not counting the weekend is we now we need to add them to open record set form table holiday and we open now snapshot we set the initial Aikau equal to 0 at the beginning and then do did said you did to started and we use the roof to wine i count is less than num day oh here normally and then we si did youdid equal to do is +1 eve weekday use a weekday function we did you did we keep Monday we start from Monday it is less than Sigma the we taste within second then we use the eyes team dawn now five first five the first number five foot information from the holiday day under the holiday table we have to have the holiday dead feel in their equal to and with this UT spouse I before the day and then duty if is K no match then I cow equal to I calm first one in D another in day for me and Lou after Leuven and with si this function and you did equal to our duty and after this we've done put the connection is needed for the considered whole and then zip record set equal to nothing and then set the DV equal to nothing exit none database and exit function okay look like we done with the cool because we have to check which it the way gives weekday and we go find some way they did it is no holiday date in there it's not match and then we count that day and that's how before we have to check on board week day and hora deal now we need to create holiday table before we don't have anything go here and create the table beside the name as a TBL already and so we already put the code in here already is table and have for a few hurried a day to and holiday ID and every day day with a name okay looks good now we put in there like gender age for this new year several 18 custom day and very full season shall we rely for foot of divine that's already did save it now we need to for it our photo here we have function but we have to started with the food started let me don't we have the started here and then um I can put like a thin day man away because they have been um here in the next Kingdom he said because it is famine often you use field number number B I just put day 50 date and then it's due in ten day and next why we have to assign a due date to and do de not that we opted to study we can assign we just do like this we assign if you did equal to AB you did we'd have started and see how do we click this one and then we move to another box another field and the due date automatic pop-up or assign let's see we starting from the 23rd and we don't count well let's try on the authority they do on the 14 which is check on that is not counting the weekend not kind of already during this time we had the whole day on January 4th we come we start counting on the 31st and skip the first two three skip Saturday 4 5 5 6 7 8 and 9 13 and 10 on the phone you see they got 10 day which is issued holiday and it's through the frozen ice for this first holiday it's good weekend this is example of the the number that I may know is put in here following our code but if you want the number she came from the me dot num feel we have number update you after you put the number of day and now the after update function you have to put under this under the number you put a start date and then you put we have to put up date under the number after you put the number of a ending and wish me copy this code and we need this not the number of the update and the show the building now we select the uniform but we put about seven days in here and we update now we just click on this field and they do the chain to the third which is counting from 20 staff 24 house starting twenty five six seven 84 day and skip three foot and find six seven now seven dead do which is ah a photo the seventh day from the study just be one it's April Fool or you can put him and you Ed ended now the due dates into the eighth is just counting day starting 25th and no holiday no we can counter it how we use that then Quebec again we have to trade the function at the due date first don't how do a weekend and don't have a holiday because we open the record fit from the holiday and looking for that for a day day and it has a function to the other update event on the number of the other we put the number obtained and then they behave with our operator assign depend on how many do you wanna do start from the two started if you just want to cut the current a day this matter already on weekend you just do this you know the app they add to add number of day to start it but thank you for watching

Channel: T Golden Eye

Views: 19,801

Rating: 4.830986 out of 5

Keywords: Howto, how to, access 2010, ms access vba, MS access 2010, vba access, access tutorial, set due date, not count holiday, assign due date, add working day

Id: Na4kjr2EiLg

Length: 18min 36sec (1116 seconds)

Published: Sun Mar 30 2014