Search results

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 arnelgp, My heartfelt thanks to you. I was breaking my head on this for past few days till you solved it.

I tried using dsum method still it shows error Me.tlhrs.value = dsum([totalhrs],[ottable], “[Empname] = “ & [forms]![otfm]![enme] & and “[wdate]= # “& [forms]![otfm]![edate] & “#”) Hi Pat Hartman / Arnelgp Data is already stored in a table and I want to display the data in the form. It is...

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

Thank you Plog, mike60smart you have done a splendid Job your solution will reduce plenty of my burden.

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

It works. Thanks for the help Ridders. I’m working on improving my knowledge in vba.

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

I will try that out Mark.

I have a code that downloads recipients of outlook sent items folder into the db. The taskname field is unique value so I could not add the task name field. Only option I have is to add recipient list to the field next to taskid field.

Hi jdraw, If a task is being shared by two or more employees this situation occurs. The username is the recipient names of outlook mail. Basically the workdata table gets input from email recipient list.

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

Thank you very much JHB and others. This works fine now.

Hi all, Thanks for your immediate attention, I have just attached the sample db which could explain the problem. Kindly check estqy in queries. Hi jdraw I am in ist and wanted to convert to est

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

My hearty thanks to Ranman/ Cronk. Code works well. Though I am facing a new challenge now I will post it as new query since it’s partially connected to this. Thank you very much for the support.

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

Ranman,BoBaxter,arnelgp thanks for your solution. It works like a breeze. Aside to arnelgp I owe you one.

Hi Team, In the attached test db I am having a table with data and a form to choose the criteria for reports and a query which displays the result. In the tables in_time field I have date in general format in the form when I choose the date field and Shift combo box field (troublesome area) I am...

Hi team, Could you assist me in this issue. Or could you guide where to look for answers to this?