Recent content by chhines

I've tried several ways to get it done but I keep ending up with errors. I've added to the DATEREVIEWASSIGNED After_update procedure and I also have it in the property for the default value. I realize at this point I probably shoudn't have it in both places, but I was just basically testing...

I thought I had closed out this thread, but apparently not. I awarded points to namliam. Anyway, I got this all working from the perspective of a select case statement. I have another question. I've tried several ways to get it done but I keep ending up with errors. I've added to the...

I found a really neat URL on the web entitled, "How to Send E-Mail From MS Access using Outlook" and decided to test it with my database. I’ve gotten so far with it, but I have an additional question and didn't get a response back from the site owner, so I wondered if maybe someone else knew...

I'll give my points to namliam as he helped me the most during this. I ended up using a Public Function with the select case statement but moved it outside of the module it was originally in. Someone else suggested I do this. I had to tweak the controls on the form a bit, making them bound...

Also, this kind of goes back to the original issue I thought I was having. Should this go on the Review_subform and can the Review_subform "see" items in the "Task_Subform". When you open VB to put in the code, you know how VB sometimes autofills and gives a drop down for you to choose your...

namliam, Thanks again for your most recent reply. What if the field I'm using it in is on a subform and the combo box I'm calling from is also on a different subform, both on the same main form. I.E. Main form = Input Facility Task Reviewer Subform 1 = Task_Subform (where cboTaskType is...

Hmmmm.that is interesting. Actually, I had already set the combo box like that, with the column hidden. That me.combobox thing goes in the vb section for which form? Would it be the main form, "input facility task reviewer" or the "Task_subform" or the "Review_subform"? Thanks.

Namliam. I don't know what the steps are to call it like you are saying. I've already added it all to a table and called the field for the days "DueinDays". However, I still will have to call it in a sequence using IIf or Select case to run the calculation won't I? I.E. I still will have to...

Thanks bob for your reply. I'm still confused at the syntax you've given.:confused: When you say you have to pass the field [DATEREVIEWASSIGNED] to the function, but you give it a different name (i.e.dteDateReviewAssigned As Date), yet at the same time you call TASKTYPE by its real name...

Ok now I'm really confused::confused: I've created a custom function. I've attached the syntax. My Due date field just displays #Name? all the time now. It doesn't matter if you select an option from the TASKTYPE box or not. It also has occurred to me that maybe I didn't select the correct...

Thanks for the replies yesterday guys. I initially got it working with my IIf statement. The logic that namliam explained for the If statement made sense, which allowed me to fix it --for the time being. Then, my staff hit me with "we want to add 5 more types to the task table." Thus...

Ok guys, what am I doing wrong? I tried the suggestion by namliam to make the due date field formula [DATEREVIEWASSIGNED] + IIF....that just kept returning a value for DUEDATE of 60 days beyond the DATEREVIEWASSIGNED. I also tried using the OR in the statement too, which cut down the coding...

Thanks guys for the quick responses. For what its worth, I use this site a lot searching Posts that help me with things similar to other's problems, thi is just the first time I've actually posted. DCrake, can you be more specific using my example for the case statement? I'm much more...

I have a very long IIf statement. I think maybe I've reached the limit of how many choices you can have in the control source "Build" statement of a text box on a form. Really, the IIF statement is very confusing looking at it, so I suppose there is a better way, but I don't know how. When I...