Search results for query: *

You're the man PHV. Worked like a charm.

Nothing. I stays with the last TRUE value in the list that was selected.

I think I've figured out how this can be done but I'm not sure how to implement it. I'm sure it can be done if I use an IF...THEN statement in the AfterUpdate event in VBA. I would check to see if the number entered is equal to a number on the list (pulled from...

This can be solved with a simple INDEX command. No VBA required. If all you're hoping to accomplish is to bring data from a specific row number up to row 3 in the same column. Try this: =INDEX($A$10:$A$500,A1-9,1) Copy this over changing your array to the corresponding column. Let me know...

You could also try using the AND function. It looks like you have 2 criteria that need to be met in order for the bonus to take effect. Try this: =IF(AND(W10<AI7,V10>AI8),"no bonus",(Y10+Z10)*AA10) Malagar

You're saying that it would be easier to use a combo box and just have them use a drop down list? I had a drop down list before and can easily go back to it. I would need it to show Item# though. As product recipes are modified to adhere to ever changing food laws the item# will change but...

I'm using Access 2010. I've also taken your suggestion about renaming. It makes sense. Would I presume to not use spaces (replace with underscore) in the field names as well? SQL is as follows: SELECT tblTiHi.[Item#], tblTiHi.[Item Descriptions], tblTiHi.[Cases Per Layer], tblTiHi.[Layers...

This form is getting its info from a query. The query name is "Item Ti-Hi Query". Form is named "Item Ti-Hi Form". When the user enters an item number into the text box (referenced from "Item#" field in the query) and hit enter the form fills in the other fields accordingly. I have code in...

I work in shipping/receiving for a food shipment company and I'm trying to set up a database of all of our product lines. I'm new to Access (using 2010) but I've dabbled in VBA for Excel. I've got a basic Form set up right now with the hopes that any user can come in and use this to look up an...