Search results

Hi, I agree with your suggestion. But now I tried running the code but its not giving the desired results. For emp4 starting from second row freeat shows the same value. I have given the screenshot. I think I should be more clear.Though it is a calculated field. It has to calculate freeat time...

Thanks for immediate response. I tried using it but getting error as Microsoft access cant find the field referred in your expression. I adjusted the space between taskt time. Assigned it as a variant and choose in the ![freeat] field. added a square bracket to taskpick Still getting that...

Hi Experts, I am using the below code to update the "freeat" time but I am not getting the right calculation. Could you assist? Find the screenshot 1) In the first row "freeat" time for emp4 is "01/11/19 3:10" when he picks the second task ( second row ) he will be free at "01/11/19 15:10"...

In this case 1) There are 6 employees 2) First 4 employees are given tasks e.g. Emp1 is having 1 hour (tasktime) worth work so he will be the first person to be free among the four at 1:15 (freeat) 3) so he will pick the first tasks with status pending ( task5) so he will be free after 5 hrs...

Hi Plog, Thanks for the assistance. I have given two screen shots for your reference one is how original status will look like another will how our output should look like.

Hi Plog, Thanks for your immediate reply. Code looks good. Please help me out in getting this sorted. I can change the avlfrom and avlto fields in emp table to dd/mm/yy hh:nn format so that will it reduce the need of "Function is_Available" Also can the SQL be modified to show only one...

Hi Experts, I need your suggestion in updating this code. Currently the code compares and suggests which task can be assigned to which employee by comparing Tasks with Employees till the specific employees available time (emp available) field which is in tasks table but due to needs that field...

Hi Sir, Resolved, I owe you a ton. I really could not say in words how many employees hours of worth work you have saved by giving this code. Thank you thank you thank you.

Sir,, Almost everything is fine. I am able to open the form repeatedly now. But Availability time is not getting updated for the succeeding set of employees.. I mean If the availability time is also shown next to the Emp name it will be good.

Hi Sir, This code works like a breeze and this is what I wanted. One small problem when I close the form and reopen it I am getting " Run time error 94 Invalid use of Null" I understood the line arrAvail(UBound(arrAvail)) = ![Emp Available] Is not updating the time , I tried adding # to the...

Hi Sir, The tasks will automatically get downloaded to the "Tasks" table so is there a way to use it as template instead of "task2" because we are using the Tasks table as primary table . 1)So instead of adding an entry to tasks table can we just edit and add the emp name 2)One more thing can...

Hi Experts, I need your support in fixing a code. My requirement is to add names of employees from "emp" table to "Tasks" table where employee name is not available (is null) and the name repetion should happen if the availability time of employee is less than task time. Emp1 who will be free...

Hi arnelgp sir, I love this. I really really mean it. Finally you resolved the query. Great.

Yes sir, is there a way to auto assign tasks for an employee. And I want the time of the last task. So that it will be the When he can pick another job. Basically queue time.

Hi isladogs, Though your code was helpful, I will try to customise to meet my needs. I a, sorry if I didn’t get it right in the dummy db. However thanks for the help.

Hi, Gone through your link. Very useful have bookmarked it and even taken few printout as many of these are frequently used.

Hi all, Thanks for your immediate assistance all of your answers are too close but due to its complexity I could not move further. Let us not focus more on the table part since I have just created a dummy db file of slightly complex and bigger database and in the original database employee names...

Hi arnelgp Sir, Thank you as always your answer was to the point. Your code gave a time of 04:00 AM which is correct. Since after the completion of Task1 he will pick Task4 and be free at 04:00 AM. I needed one more step after achieving this 4:00 . Which means after completion of Task4, he...

Hi Experts, I despirately need your assistance in solving one of my problem. I wanted to communicate the correct pickup time to those who delegate tasks to my team. I have attached a dummy db for your reference. Scenario : I have 3 team members and 15 tasks. First member gets free by 1AM and...

Hi Experts, I have three tables as user,task and worktime each with an autonumbered field as primary key. User table has list of users,Task table has list of tasks to be performed by the users and worktime table will be having taskid , wrkid, start and end time of the task. I have set the...