Search results for query: *

Thanks for the help! Learn a new best practice everyday ;)

I have a table "Invoices" that has 20 fields named item1Cost, item2Cost, etc. This table also has 20 other fields named item1Type, item2Type, etc. These types are looking up 1 of 7 values in another table "Costing_Types". Now I would like to get the total sum of all items per each different...

I finally figured it out! All it needed was a requery. Very elusive. Thanks for the help Jeff and for affirming that the proper way to do this was, in fact, with a WHERE referencing a textbox in the subform. Thanks again. -DK

...and I should say that when I tried WHERE (((Bonus.bonusID)=[Forms]![Bonus subform]![Bonus ID])) in my row source as a limiting strategy, it returned no entries. ...thanks again!

No problem! Here is the SQL. The query [BonusID to valueList] looks like this: SELECT Bonus.bonusID, IndMultValues.valueList FROM (Bonus INNER JOIN [BonusID to GradeRating] ON Bonus.bonusID = [BonusID to GradeRating].bonusID) INNER JOIN (IndMultRouting INNER JOIN IndMultValues ON...

Depending on which ID is being referenced in a subform, I want to restrict the list of values in a Combo Box using a query: • I have a subform [Bonus Subform] that is linked to Table!Bonus. • I have a query [Bonus ID to valueList] that associates each Bonus ID to a list of values. The way...

Ah, right...I should have said why I didn't want to do that. Well, although I think the interface for controlling records in Access is simple to understand, my users will probably not think so. These users would much rather just enter in a value in a box, rather than arrow through records or...

I'm not even sure how to structure this. I have a main form Forms![User Master] which references Tables!Employees. In this form is a the subform object subformPromotions which in linked to Forms![Promotions subform] which references Tables!Promotions. The relationship from employees to...

Well, it actually looks like I won't have the opportunity to implement this feature for the next few days (I need to get a few other problems out of the way before I'm able to tackle this one). So, while I still have you here (thankfully), if you could help me take a deeper look at the third...

Thank you so much for the response. I think I was able to disect that suggestion. I have not yet begun creating my forms, so I probably won't be able to test that out until tomorrow. But when I do, I'll post my results here. Hope ya got this one flagged! :) But, from what you said, it...

Unfortuntely those values will change each year, so I am not able to hard code it in. This is how I've sketched it out so far...(table names with fields and descriptions). Performance Rating Table ___________________________ Performance Rating ID: autonumber Individual Performance Rating Name...

I'm afraid I don't follow. I don't understand how the query will restrict the range of data a user can enter. Here's the practical: Table:Performance contains these fields ID Performance Minimum Bonus Multiplier Maximum Bonus Multiplier The user, in this case a department manager, will rate...

Hello, Depending on the value of combo box #1, I want to restrict the range of text box #2. Combo box #1 will reference a table; each row in that table will have, in addition to an ID and Name, a minimum value and a maximum value column. Text box #2 will be limited by the values of the min...

I thought it would be something like that. But if I have a dozen fields on this form, then I will need two dozen buttons (ascending, descending). Is there anyway to tell it "the current field" or something similar so it will use the field my cursor is in? Thanks Bill.

In trying to create a database that will be used by someone who knows nothing about access, I want to place a sort button on my forms where when the user has their cursor in a field, this button will sort that field accordingly. Currently I have a macro that simply runs the command...

Thought I would post my final results here. Textbox named LocationResult on form Assets contains the following expression: =IIf(IsNull([EmployeeID])=True,[hiddenAssetLocation],DLookUp("[DeskLocation]","Employees","[EmployeeID]=[hiddenDeskLocation]")) whereas: a)...

Ken, Granted I'm somewhat confused by this, but I think you were right the first time. Because the expression works fine when using "True" and "False" and when I only substitute one of those the substituted part works fine (while the one referencing a column yields an...

I'd be happy to clarify Krystoff, and thank you. Most of that was accurate: I do have EmployeeID on this form, called Assets, but I do not have Employees!DeskLocation. Location is not on this form either, other than my reference to it in the expression text box LocationResult. Location is a...

Agreed. My basic understanding of all of this leads me to believe something is wrong with the true and false part. Yes I renamed the name of the text box on this form from "Location" to "LocationResult". And, yes. [DeskLoaction] is in the table [Employees]!. I've built...

Ken, Thanks for your digilence :) No, that could not be it because the IIf is evaluated fine when I substiture "True Part" and "False Part" for the last two arguments. So, the reference made in the first argument is fine. The reference made in the true part always reverts...