Search results for query: *

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

Have a form that lists all of my customers - with a "detail" button that opens up a new form with all the specifics. ie. Mickey T Mouse Account Number click for detail Daffy Duck Account Number click for detail Each customer has relationships with a variety of...

So is that assigned via code? Or in the properties of the form or textbox in the form? Which do I use as the control source of the textbox in the design view of the datasheet form? Also - a second and NEW question. Under each record there are subrecords... like so: 39842984729 Micky T...

In my database I have an opening screen - essentially a list of all the records in the database. It doesn't display all the data - obviously - just some of the key info - like an account number and a full name etc. Well, the name is split into three fields - first middle and last - but in my...

Remou - I apologize for the delay in my response. I think I may actually have my database working the way I had envisioned - and I wanted to say Thank You for all of your help - it was paramount to my success!

And I'm thinking you might want a master list table of available keywords so that you can use combo boxes to select potential keywords instead of letting users type in their own. Otherwise you might miss out on matching when one user enters "Heavy Equipment" for project and then a bidder is...