Recent content by andrew.abaye

No Please

Good Morning Folks, I have implemented an Audit Trail for my Access Database following an example I saw on Tech Republic. It is working well for other forms except for my payroll form. It gives an error: Operation is not supported for this type of object. Number" 3251 as attached even though...

I did click on the allow and I expected to see the sent message in the sent folder and in the recipient inbox which did not happen

Thank you. I was simply saying that nothing happens on the Outlook side of thing. It least it should launch outlook if it was not open and the message should be in outbox and when it is sent it will be in sent folder

I have tried both same behaviour. It does same thing but nothing happens in my outlook and the staff member don't get any email as well

Thanks so much for pointing out an in my code. I have made that correction now. I now have a popup saying a program is trying to send email on your behalf which should be but when I click allow I don't see anything in outbox or in the inbox of the recipient. I have attached my final code and the...

Hello Folks, I have created a form which allows me to print Access Report based on the criteria supplied on the combobox of the form which works fine. I have a second to email the report to the user and I have created a query which have the recipients email addresses. I expect the function to...

Thank you all Folks. I figured my error after reading your responses and I got my expression working. This is what worked =IIf( [duty_type] ="Full Time",( [amount] *1),IIf( [duty_type] ="Adjunct", ([amount] *0.33),IIf( [duty_type] ='Sabbatical',( [amount] *1),"Amount Not Found")))

Yes

This is what I came up with based on your example and it returned the expression you entered contains invlaid syntx. IIf([duty_type]='Sabbatical',[amount]*1),IIf([duty_type]='Adjunct',[amount]*0.33),IIf([duty_type]='Full Time',[amount]*1))))

It returned syntax error. Could you provide me a workable code. I am new to Access Expression.

My name is Andrew Abaye from Nigeria. I use MS-Access to a reasonable extent just that I left it since 2006 so I have forgotten how some things are done.

Good day everyone. I am trying to use the Access iif expression to calculate the basic salary of employees based on the employment type but it is not working. See my iif statement below. The field that has the value is Amount while the field that has the employment type is duty_type...