Recent content by wxkeep

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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