Search results

Forgot to mention... I forgot to mention - I've been able to do this in the past somehow, by creating an unbound combo box on my main form. Then, when I type in the value and press enter, it goes to the matching record in the main form. Sound familiar to anyone? I have been able to create the...

Does anyone know how to design a subform that can be plopped on a main form to find records? I have a customer table, and I want to be able to find a record by typing in a keyword from the customer name on a subform that is next to the main form......important that the entry does not have to be...

Hi, All! I have a report that adds up the total number of items sold, and groups by item. So, I've sold 18 of part a, 25 of part b, and 100 of part c. How do I sort by the calculated field (which I've named Sum Total) so that highest sold items sort at the top? Any suggestions?

Can someone tell me how you attach a database to a forum post? Thanks.

Create your country and state table separately. Then, add a state field to your main table. Then, create a relationship between your state field in your main table, and your state field in your country table. Then, when you create a query, form, or report, include the associated country field -...

Without knowing whether the additional notes are in a table, or, is simply a short statement that you want to add to several exisiting entries, I can tell you that a query would be run in either case. If you have a statement to add to several entries, write a query that filters those entries...

I have executed such daily tasks with a fair amount of ease by doing the following: Ensure that your excel spreadsheest's fields are the same definition (i.e. text,number, date, currency) AND in the same order as the table you are going to add into. You can simply copy the records in excel...

I often create such unbound forms from which to run reports. for fields that I don't want to specify, I create a default value on the form that catches all records. For instance, I have a db that tracks calls from Me & two other reps. all calls are placed to a Rep Code Rep1, Rep2, or Rep3. When...

Seeing as you want to have 2 different types of formats, I don't think there will be 1 input mask that you can use that will be "smart" enough to identify one or the other. Rather, you can periodically run a query that filters out any records containing fewer than 5 digits, and tacks on the...

This doesn't say much, you will need to say what kind of table you are trying to create and what kind of fields you want in it.... your request is a little to vague to help you out with.

Yes, for leading zeros, put the placeholders in the Format section of the field properties in table design view...I haven't gone in and tried it, but, if you wanted a 1 to come up as 0001 you would simply enter 0000 in the format field.

Table Validation Rules, multi fields....Solved!!! Thanks, guys - I actually figured out how to make this work without a form....and Pat, although you are correct that you may not reference more than one field in a field validation - you are free to do so in the table validation. I wrote the...

Hello, all. I have a table that contains a field (list) for categories [Inquiry Type], and a field that tracks category of any follow-ups [FU Inquiry Type]. The rule is: If [Inquiry Type]="F", than [FU Inquiry Type] Is not null. For some reason, when I'm entering data, the validation rule...