Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bartoki

    Sum Multiple fields in a query

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

    Sum Multiple fields in a query

    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...
  3. bartoki

    Combo Box values from Query?!

    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
  4. bartoki

    Combo Box values from Query?!

    ...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!
  5. bartoki

    Combo Box values from Query?!

    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...
  6. bartoki

    Combo Box values from Query?!

    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...
  7. bartoki

    Control most recent entry on subform from form

    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...
  8. bartoki

    Control most recent entry on subform from form

    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...
  9. bartoki

    Restrciting range of entry

    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...
  10. bartoki

    Restrciting range of entry

    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...
  11. bartoki

    Restrciting range of entry

    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...
  12. bartoki

    Restrciting range of entry

    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...
  13. bartoki

    Restrciting range of entry

    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...
  14. bartoki

    RunCommand SortAscending error

    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.
  15. bartoki

    RunCommand SortAscending error

    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...
  16. bartoki

    Newbie IIf - IsNull problem

    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)...
  17. bartoki

    Newbie IIf - IsNull problem

    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...
  18. bartoki

    Newbie IIf - IsNull problem

    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...
  19. bartoki

    Newbie IIf - IsNull problem

    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...
  20. bartoki

    Newbie IIf - IsNull problem

    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...

Part and Inventory Search

Back
Top