IIf statement not working, SELECT case instead
Well, NeoPa, I tried that. I don't think with the flawed design that we'll ever be able to get this to work though.
I tested it and copied it exactly as you said.
I think maybe I missed something here though.
In your earlier post, you said, "add an event procedure handling entry into the control, and if the current value is still Null, then change...
chhines
Last Activity: Nov 17 '09, 06:42 PM
Joined: Oct 29 '09
Location:
-
-
IIf statement not working, SELECT case instead?
NeoPA,
This actually was my first database project, so there was a lot of learning in ALL aspects. So I'm sure it is much flawed. Ultimately, just to get this done, I'd rather use the approach where we call a procedure to check if it is NULL and then put in the default date, so let's go that route. How do we do this?
After doing much thinking about this, I came...Leave a comment:
-
IIf statement not working, SELECT case instead?
NeoPA,
Yes, essentially you are correct. As you say, "store the original date the record was entered into this field (DATEREVIEWASSI GNED) until somebody chooses to set it explicitly, then, once that has happened once, to disallow any further changes to that field?"
That is what I want to do.
While it does appear confusing, actually the completion...Leave a comment:
-
NeoPA,
I've tried several ways to get my date assigned to grey-out and disable after initial update, but I can't get it to work.
I've added to the DATEREVIEWASSIG NED 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 to see what happens in all instances.
I want the DATEREVIEWASSIG NED...Leave a comment:
-
IIf statement not working, SELECT case instead?
NeoPA,
I think I have made a grave error in the explanation of my problem here.
I'm attaching a copy of the database that ADezii asked for when he fixed my original problem.
The form you would want to look at is the Input Facility Task Reviewer.
The only time a "record" is brand new is when it is entered for the first time via the Task_subform,...Leave a comment:
-
IIf statement not working, SELECT case instead?
NeoPA, I'm not sure I understand the logic of your suggestion. I'm sure it is painful for you to have to spell it out to me like a baby, but in my original post, it says NEWBIE. I'm not sure why we are trying to assign the IsNull value to the control. It should never be Null, so I would think this is the least choice we would want to test. Is there a coding sample somewhere so I can...Leave a comment:
-
IIf statement not working, SELECT case instead?
NeoPA, you are probably correct, I'm not explaining it properly. My bad.
Anyway, once the DATEREVIEWASSIG NED is set by the first selection of it with a TASKTYPE and at the same time TASK #, which happens during our calculation of the DATEREVIEWDUE = DATEREVIEWASSIG NED + TASKTYPE select case statement from ADezii.
This DATEREVIEWASSIG NED should NOT change for the...Leave a comment:
-
Emails from access
Thanks Chip R. for the response.
I currently have an access query that populates the "MyEmailAddress es" query, which in turn is used in the SendMail module,
i.e. Set MailList = db.OpenRecordse t("MyEmailAddre sses")
I've created a MailForm, on which i have 5 combo boxes, which allow a user to pick one reviewer from each job title to assign to the project (not every project...Leave a comment:
-
Emails from access
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 how to do this. Is there a way to pull the email addresses from an Access table or form based on the ones that are chosen or “enabled”? For... -
IIf statement not working, SELECT case instead?
Yes, it will Default to the current date, but the user can also put in their own date by entering a different date in within at least the last 30 days.
This date is entered when the task(project) is first assigned and the reviewers are chosen for each phase of the review.
This is what we are actually tracking, the workload of reviews and various stages a particular...Leave a comment:
-
IIf statement not working, SELECT case instead?
Interesting replies, NeoPA and ADezii.
ADezii, you mention just locking the current text box, but won't that lock it from entering anything at all if I do that?
NeoPA, you are indicating flawed design?
If I understand what you are getting at, the main form is the Input Facility Task Reviewer, this starts out with 4 fields, a facility name, facility #, Permit...Leave a comment:
-
IIf statement not working, SELECT case instead?
ADezii and NeoPA. Thanks so much for all your help with fixing this problem, it seems to be working great now!!
More importantly, you've explained the logic to me so I know what is going on and can use the logic in the future if I want to make changes this or add additional items as such.
I have an additional question.
If I want to "grey...Leave a comment:
-
IIf statement not working, SELECT case instead?
ADezii, I have some ?'s with what you've done.
You mentioned you put the Public function in the SendMail Module.
Why there?
I actually wasn't even using the SendMail module yet, and I'm not sure if it will work due to a limitation in Outlook, so will it work if the SendMail module doesn't?
But anyway, why did making it a public function in SendMail...Leave a comment:
-
IIf statement not working, SELECT case instead?
ADezii, I've attached a copy of the database---modified.
I didn't put a lot of data in it, it appears to be still making the same error with what I have in there.
Hopefully you can figure something out from what I have in there.
If you need to, add additional data, or let me know and I'll add more records. Thanks again....Leave a comment:
-
ADezii, I'll try breaking it down some tonight and will repost back here something you can work with...Thanks.Leave a comment:
-
IIf statement not working, SELECT case instead?
ADezii. When I try to add the debug line, I get, "compile error: Invalid Outside procedure." I've tried adding it in the "Input Facility Task Reviewer" portion of VB and also in the "Reviewer_F orm" portion, same error. No I didn't forget to set the function as the control source for [DATEREVIEWDUE].
NeoPA, no I didn't try your idea, it...Leave a comment:
-
IIf statement not working, SELECT case instead?
Thanks for all the replies.
Unfortunately, I still can't get it to work.
Everything I try, the [DATEREVIEWDUE] field just shows #NAME? in it.
I changed what appeared to be a couple of errors in the function call, as the [DATEREVIEWASSIG NED] text box was named [DATEREVIEWASASS IGNED] in ADezii's reply.
Also, I changed the Task subform in the string variable,...Leave a comment:
-
IIf statement not working, SELECT case instead?
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 try to add additional choices, nothing happens, I save, get no errors, but the new choices don't work! I am trying to calculate a due date [DATEREVIEWDUE]text...
No activity results to display
Leave a comment: