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!

Recent content by wxkeep

  1. wxkeep

    return record id of row with largest value

    Alright - at this point, I just used a DAO recordset to pull it Dim rs As DAO.Recordset Dim db As Database Dim strSQL As String Set db = CurrentDb strSQL = "SELECT size_ID FROM giftSizes WHERE (giftMin < " & Me.gift_Amount_TxtBx.Value & ") ORDER BY giftMin DESC"...
  2. wxkeep

    return record id of row with largest value

    tablename: giftSizes field to find largest value in: giftMin The query would look something like this: SELECT Max(giftMin), size_ID FROM giftSizes WHERE giftMin < Me.textbox.Value textbox.value = a user field where a given gift amount is inputed. The query needs to return the row id for the...
  3. wxkeep

    return record id of row with largest value

    Back in the saddle. Been a while since I've done any VBA coding and the software has seen some changes since last I played with it 10 years ago. Here's what I'm trying to do (short term) IN VBA - use a query (or DLOOKUP etc) to search a table for the row that contains the highest value that...
  4. wxkeep

    Joins and Unions

    That definitely gets me started - and I can see where you're going with it. One question, since that is left joined - it is going to give me a list of all sales for the selected period - regardless of whether or not that salesman had returns (which is what I wanted) but it doesn't look like it...
  5. wxkeep

    Joins and Unions

    Have two tables Sales -Sold Date -Salesman -Amount Returns -Return Date -Salesman -Refund Amount Anytime a sale is made - its recorded into the sales table. Likewise anytime a return is made - it's recorded in the return table. I have a form - that accepts dates- to build a custom query...
  6. wxkeep

    Totals in queries

    I've got a db - that tracks customers and sales numbers. Each customer may have multiple sales, and thus, multiple entries: sales id | Name | Amount 1 John 500 2 Mark 500 3 Luke 100 4 John 200 I run a query on this table that...
  7. wxkeep

    Simplify a report

    For the past year I have been responsible for a database at work. In the beginning it simply kept track of loan applications (date, score, name, source, decision, etc). And I had one report that would show all the applications as well as summary numbers (total amt approved, avg credit score...
  8. wxkeep

    Simplify a process

    It won't post. I click submit post - and it doesn't do anything...I'm confused.
  9. wxkeep

    Simplify a process

    For the past year I have been responsible for a database at work. In the beginning it simply kept track of loan applications (date, score, name, source, decision, etc). And I had one report that would show all the applications as well as summary numbers (total amt approved, avg credit score...
  10. wxkeep

    Look at next record

    But then, how do I automate that temp table? I like being able to just double click the query and get my results. And I really don't want to build a whole bevy of forms and such just to handle this one function....
  11. wxkeep

    Look at next record

    I have database that runs a query across several tables. That query's results are then sorted by department, office, employee, date, receipt order. The problem is - there is no unique or primary key anywhere in this data. The departments are numbered 1-25, each department has an office...
  12. wxkeep

    Determining if primary key exists

    That's PERFECT! Thank you so much for making this simpler. I hadn't even seen the DLOOKUP option yet!
  13. wxkeep

    Determining if primary key exists

    I know this question has been asked numerous times - but I have to be honest - I've become very confused reading through posts looking for answers. I have an unbound form. Where the user is going to create a new record in tbl2. tbl2 has a field that is linked to a primary key in tbl1. And...
  14. wxkeep

    Mimic a Sort/Group list on a form

    If I could do a continuous form with subforms I think I'd do just fine - if I could somehow to define the subforms filter criteria by its field in the main form - but it won't let me add a subform to a continuous form. I'm running out of ideas - but I'm sure this can be done. I just need...
  15. wxkeep

    Mimic a Sort/Group list on a form

    I can manage to generate the list in the way I want via a report - but the problem is that I can't add anything for an OnClick event to open the other form - and I can't add that report to a form. I mean - I've thought about just using a datasheet view - because when I open my primary table -...
See more

Part and Inventory Search

Back
Top