Search results

Hi experts, I want your assistance in getting the loop correct. "Taskpick" field in "tasks" table should be in between lfrm and lto fields of "ests" table 1) If the said condition is "not met" then vba should look for next record is ests table till this condition is met or till the end of ests...

Hi docman, dbguy, micron, My sincere apologies. Though I have cross checked the format of form field, query fields, It looks like I didn’t not change the format of specific field in the table. When I checked today the field was remaining as a text field which is the route cause of this result...

Yes. You are correct. I am just travelling back to home. Will reach and share the requested data.

Hi, Other than “ename” field all the others are date fields using general date format. Freeat is date field too.

Hi dbguy/ Docman, This is what I am getting as result when I run the query “ests” and use * instead of top 1 parameter. 6/2/2019 4:00 PM 6/2/2019 6:10 AM 6/2/2019 7:00 PM 6/2/2019 7:45 AM Look how access ignores (am and pm ) but sorts only the numbers. LOL. But I want result as 6/2/2019 6:10...

Hi, The select query helps me to identify the correct “test” value or the correct Ename. So if the sort order is not correct I am not getting the correct value

dd/mm/yyyy hh:nn AM/PM format European format.

Hi DBguy, General date format is the one I am using

Hello Experts, I am using the below code to find the top value ( minimum value ) of a recordset but sometimes this is not showing the correct value when I open the table I was able to identify this code is not reflecting the correct ascending order for dates in this field. I browsed through our...

Hi Bastanu / Doc Man, Thanks for your immediate response yes both of your code works.Ofcourse I did make certain changes to meet my need... Thanks for your timely help.

You are correct. However in the second loop I want either second employee or first employees second pickup time whichever is less. So in the second loop it should show us the employee listed in the second recordset in the third loop person in the third recordset and so on. For achieving this I...

A doubt there. Since we are ordering the recordset by freeat and using .movefirst isn’t the same record or the same employee will come first for every loop.

I think we need that functionality to achieve the correct order of delegating tasks. Since when some 50 plus employees are there one person could have taken multiple short tasks and get free well before others so this persons name should repeatedly come in the loop than with others who has...

Initially I had the same opinion which you had. But that is not the case. Let me explain with an example of two employees, if the first employee is given a task worth 1 hour and second employee with task worth 5 hours the first employee will be free well before second emp. So first employees...

Hi Vlad, Thanks it’s very close to what I want. If it’s the first loop I want the first record of rsemp recordset for the second loop i want to move to second recordse for third loop third recordset of rsemp. How to achieve it.

Hi Ranman, Thank you. But I am not very strong in creating a query which could meet this requirement Is there a way in vba itself?

Hi all, I am using the given code to update a set of data which partially meets my need. 1) I want rsemp recordset to be sorted based on "freeat" as soon as update event occurs 2) e.g. if first employee is free before the second employee the next loop should show first employee's name for the...

Thank you Gasman, It works as I wanted. Thanks for the valuable advice Majp

Hi Team, I have a field "taskpick" in mm/dd/yy hh:nn format and another field "tasktime" in decimal format with 2 decimal points. Here is the issue 1) I need to add taskpick field with tasktime field and get a new field "freeat" which should be in mm/dd/yy hh:nn format I use the below code...

Hi Isladogs, Thank you. I am looking at the DB downloaded from your site, Looks great. I need to work how to get that concept into this DB. Meantime I am sharing my DB for your reference it would be of great help if you can provide a way forward. You can click the update and clear buttons to...