Search results

Hi experts, I am going to ask an pretty old question. Though I researched everywhere I could not figure out a solution and I strongly believe you can help. I am trying to use sql insert into statement to update a table with form data. But when I break the code into multiple lines I am getting...

Hi experts, I’m using a dark themed form since we cannot change the colour of default scroll bars I have taken activex scroll bar and was able to change the colour. But after I finish scrolling the thumb starts blinking which looks awkward.All I needed is to stop that blinking. I tried setting...

Hi Experts, I am using a form with dark background whenever I open it the cursor is invisible. When I checked it deeply I understand cursor is in the same dark color as form field so Users are unable to view. Is there a way to change the cursor color to white?

Hello experts, Could you assist me in changing the colour of title bar. There were certain suggestions asking me to change the theme settings of windows but I want only to change the colour of me access form. Is there a way? I browsed but did not find a solution I am in need of. Could you assist...

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...

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 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...

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 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"...

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 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 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...

Hi experts, I was using the below given code to capture data in a table sub test() Dim db Dim rst Set db = CurrentDb() Set rst = db.OpenRecordset("select * from mytable") . . . . And close record set and database after getting data updated but I got some information stating the...

Hi team, I am having a table with three fields named Empname, Wdate and totalhrs. I am also having a form with same names. When I choose empname and date in form the third field has to show the sum of totalhrs. Since the totalhrs has the chances of having a time more than 24 hrs. The sum query...

Hi Team, I needed assistance in fixing the query in the attachment. I needed the grandtotal column to show the aggregate of time spent on that task. e.g. first two rows in the grandtotal field should show 5:00 ( Total hrs. spent on the same task) and last two to show 2:00 hrs. I have done some...

Hi Team, I want to get the count of null values of a table to be shown in a text filed of an unbound form. So I am using the below given code in the control source of the field however I am getting an error could you help me out? =count(iif(isnull(“[tablename]”!”[fieldname]”),true,1,0))

Hi Team, Currently I am using this code to dlookup Taskname which was working fine. DLookup("taskname", "workdata", "empname = '" & forms!dailydata!Name & "'") Now I am starting to get multiple names separated using semicolon in the form field"Name" if there are multiple names the dlookup is...

Hi team, I have a table with field name time in general format (5/12/2017 7:05:10 AM) and I wanted the time to convert into est using a query. So I’m trying to apply the dateadd function in criteria row Dateadd(“h”,-10.5,[time]) Time is the field name in the table which has to be converted...

Hi team, I am using the below given code to download mails into my db it works fine. However when downloading data from .to field I have a trouble sometimes emails are addressed to multiple recipients the current code only downloads data of one email address I wanted to download all the...