Recent content by InDFW

The first article describes exactly how i have always created my combo boxes and explains exactly why i have always had problems with them. 2nd article is same thing as PNGBill just suggested, and seems to be a good solution - can't believe i never thought of it. thanks, y'all!!!

this is a good idea - I'll do it this way and it should eliminate my problem. Thanks~

oh wait - dang - i'm so sorry! i have a typo - here's what my question should have been: I have my table set up to lookup value from another table and have created the relationships. Both tables have unique IDs (autonumber) as the primary key. When i add the field to the report, the unique...

In my tables, I created a combo box where it looks up the value from another table. "Look up" may not be the correct term, but it uses the values in the other table as the drop down box choices.

I have my table set up to lookup value from another table and have created the relationships. Both tables have unique IDs (autonumber) as the primary key. When i add the field to the table, the unique ID appears, and not the text value. Is there a way to fix this, or did I set up my...

I found how to create a Union Query, so first problem is solved. As for the 2nd issue, I may just have to do it manually?

I am working with a database that was created weird and I am trying to fix it. 2 Main Issues: 1. Many tables, all of which contain some similar information (i.e. Product, Lot, StartDate). How can I create one separate, "live" table or query to list these 3 field from all tables? (By live...

Thank you so much! I have to find and delete/void the duplicate entries before it will let me save, but looks like this is exactly what I needed.

If I understand what you are asking, your issue should be resolved by following these steps: 1. TOOLS 2. RELATIONSHIPS 3. If your tables do not appear, add them ........a. RELATIONSHIPS ........b. SHOW TABLE 4. Left Click on the Invoice Number, keep the button held down, drag to Field1, let go...

I am trying to prevent duplicate entries, but the record is only duplicate if 3 fields are identical between records. For example: CC# (unique) Number (*) Title FromRev (*) ToRev (*) Changes Void If [Number], [FromRev], and [ToRev] match another record, the user should not be allowed to go...

thank you - that article looks exactly like what i needed! regarding the compact error - is this somthing that should be addressed? i thought it was good to have compact on close turned on?

It makes copies of itself - some can be opened, some cannot. I try to delete the smallest-sized ones before anyone does any work in any of them, and my department has accepted the fact that our database does this and our database is named "db1" or whatever number is the current one for the...

thank you! when i put it in the control source, it gave me an error, so i created a column in the query and did this: NewName: Mid$([MyField],8)

Where do you put this "=Right$([MyField],n)" I want to eliminate the first 7 characters of a field. Would that be: =Left$([MyField],7) Where do I put this info? Somewhere in properties?

We have a high-tech printer, so that's not an issue - the problem is me - i don't know how to do a 2-page Access report. I tried to move the information to the right and it has potential to work; however, the back-side detail is longer than the first page detail, so it is not working - i'm...