Code:
Select Case frm.TxtDoorHt.Value
mayala12
Last Activity: Aug 29 '13, 05:52 PM
Joined: Feb 13 '13
Location:
-
Thank you everyone for your help. I think I have solved this after thinking about it. There is another place in the code where we are doing something similar that I found. I have sort of copied that idea and below is what I came up with and it seems to be working. The feedback was helpful in working through different scenarios and figuring out why it wasn't working etc.
... -
Thank you for the clarification. I redid it per the below but now both of them have to be true in order to trigger the check box instead of either of them being true.
I changed the code, I hope in the proper way per your instruction to the below. Do you have any further ideas?
...Code:Select Case frm.TxtDoorHt.Value Case 78, 84, 90, 96, 102, 108 frm.chkSizeableUpcharge.ValueLeave a comment:
-
Thank you, I understand what you're saying but when I try and nest them the way that I think that would normally work with a If Then Else scenario, it doesn't work, it still will check the box when the height is non-standard if I put height first when I nest it, than it will check the box for the height if it's wrong but not for the width if it's wrong and the height is ok. Same if I swap them, it will do the width but not the height.
...Leave a comment:
-
Multiple fields options controlling one checkbox
I have a situation where I have a checkbox that is supposed to check if one of two criteria happens.
I can get it to check if one of the criteria is true but I'm having issues having it check if the other is.
So if one of the two cases below is true the chkSizeableUpch arge checkbox should be checked. But what's happening is that it's only checking the box if the txtDoorWidth option triggers it. It's ignoring the... -
Thank you all for your help on this, I have been given further direction that allows for the first answer with the code to initially prevent decimals to be adequate, anything after that will be handled by the processes we have in place so Yay, no coding required. But the help on that code to prevent the decimals will be very useful, so thanks again!Leave a comment:
-
Thank you, I used the first options and it might work for probably 90 percent of the situation. The problem 10 percent is as follows:
The users first picks Product 1 which allows decimals
Then they enter the dimensions in feet and inches for both height and width, let's say 4 feet 2.25 inches
If they want to change the product line, we have it set to keep the existing dimension to make the program more user friendly...Leave a comment:
-
Validation based on numeric type Access 2003
I have a text box field that is used for putting in the size in inches of a product we sell. We have several different products that use the same box and all but one group can have decimals 2.25 (as an example). However we have one group that must be to the nearest inch.
What I would like is for the validation to pop up if the user enters a decimal that warns them it's not available and prompts them to correct it. I have the validation...
No activity results to display
Leave a comment: