Search results

Yes, but to what field? Do I need to create a new field in my main table? (not desirable)

Okay, I'll be more specific. I need a function that will copy all the records associated with one "filing", assign new ID numbers to them, and make new records out of them. But sometimes they won't need every single record from a filing, and will want to choose which ones not to include. What...

I need to have a query-based form open and allow users to check off (or otherwise indicate) which records they want to update. I tried having a check box on a continuous form, but when you check one, you check them all. I did a search on this, and saw that if you make the check-box bound, then...

Bound to what? What do I bind the checkbox to? I want users to be able to select which records to update, leaving the other records alone, so I have a continuous form with checkboxes. I am basing this on a query pulling from multiple tables. What do I bind this to so that I don't change...

Excellent. Thanks for the great help and the fast response. This works, but unfortunately I'm going to have to try another direction I think. Adding in the DMin field narrows it too much, and it also filters out any blanks, which I can't have. Thanks for your help though, and I'm going to...

Shoot, actually it's the reverse. I rewrote things to make it simpler, but ID is a number and num is a text field. I tried it anyway, and it wouldn't accept the syntax, at least in the criteria (design view). I took out MaxNum: and it accepted the syntax but returned a type mismatch, I assume...

I need to find the largest and smallest values in a table based on the Primary Key for each record in a query. For example. Table1 ID A B C Table2 ID - Num A - 1 A - 2 A - 3 B - 1 B - 2 B - 3 B - 4 C - 1 C - 2 I need it to return: A - 1 | 3 B - 1 | 4 C - 1 | 2 I have searched through the...

Here is my code: rs.FindFirst "[Field1] = " & string1 string1 = "2112-E" But the vb is interpreting that as "2112" minus E, trying to subtract the E. Any way to get this to interpret this string as text only?

Sounds like you've got it working, but need to put some code in the "Open Form" event to reference this.

Bingo! Thanks

I am getting an error when I try to use an expression in a control source with a particular field in a query. So I stripped it down to the bare minimum and just put an equal sign in front of the field name. This works for every other field in the query, and this field works if I don't use an...

Thanks, I realize that these questions must seem very basic, but a lot of times I know the concept of what needs to be done and sometimes even approximately how to accomplish it, but not the details. I really appreciate the help!

Oh man, you are so awesome! By the way, I've found a way around my problem with sorting the numbers. It's temporary but should work for a few years until we need to add another digit to the field. But for future reference, is there a way to take the result of that query and sort it as you...

I have a field that needs to have both numbers and text. I need to be able to look up the highest number in that field, ignoring the text. Is there a way around the limitation of DMax on text fields? If I run it as is, then I get Z as the highest value, instead of 9, and I would get 3 as...

I want to make a report or an RTF that lists all the records in one table, and then pulls the corresponding records from another table, which may have multiple records for the corresponding master record. And I want to list them, rather than on each line, behind one another in text. For...

I fixed this, Pat I don't understand what [YourParm] and SomeValue represent. What should I be placing in these areas? Also, I want this code to open a recordset based on a query. Should I put in: Set qd = dbs.QueryDefs!myqueryname Does this replace the code I would place under the...