Search results

See here: http://www.mvps.org/access/api/api0019.htm

First, when you use the find Duplicates Wizard it automatically saves the query and assigns it a name. Usually "Find Duplicates for..." and the field name. Second, it sounds like you have set no duplicates on more than one field. Check the properties of each field in the copied table.

Well first you can't have spaces in object names. If you do, you have to put the object name in brackets. The form name is what shows in the Database Window. That's the name you have to use when referencing it. You also need a controlname there. If the control is on a subform, you need to...

lookup Looping and Recordsets in Access HELP, you will find some examples.

First, just look up DSUM in Access Help. Second, you could try removing name or other identification info from the table. But without being able to work with the data I'm not sure how much I can help further. You still haven't given me the name of the first query which I requested twice...

Lookup fields should not be done on the table level. Only on a form using comboboxes or listboxes. I've given you the instructions on what to do. go back and reread them.

As RV said, just follow the advice I gave you.

I told you the Category and SubCat combos should be unbound. That's why the values are changing when they shouldn't.

First, you didn't answer all my questions. To get the sum of the counts you could use run a DSUM in the immediate window. But that's not that important. The name of the first query is. There is no way to delete only the duplicates. What the article is telling you to do is create a new table and...

Your table structure needs work. tblMovie MovieID, MovieTitle, MovieDate, MovieDescription, CategoryID, MovieLength, MovieStatus, RatingID, MoviePoster, MovieRentCount (don't know what that is) tblItem ItemID, MovieID, FormatID, ItemCondition, PurchaseID tblSuppliers SupplierID...

You seemed to be really close with what you had setup. Why not post that and explain where the problem is. Instead of trying to modify what someone else did?

I'm not clear where you are getting this. When you are prompted like that it means that Access can't find "Forms!frmSelector!cboCategorySelect" so it assumes its a parameter and is promptng you to fill it in. Check the form name and the controlname, make sure you have spelled them correctly.

In the first query, you are getting a count, by address, of all records that that have more than one of the same address. You are using AllSourcesfromCDM as your source. The number of records returned by this query would be the number of unique addresses that are duplicated within that table. If...

An FK is not "set". Its simply a field added to a related table that holds the PK value of the related record. Generally, I name my FKs the same name as the original PK. And I use tablenameID as my naming convention for PKs.

That's closer. If a Subcategory is associated with only ONE Category then you need CatID as a foreign key in the Subcategory table. You still need a primary key there as well. If a Product is associated with only ONE Subcategory then you need SubcatID as a FK in the Product table. So you would...

yep, you would have to use the Criteria in the DMax to select the Max for both the date and user.

The problem here is your lookup tables (Cat, Subcat, Prod) don't define the relationships. If a product belongs only to a specific subcat and a subcat to a specific Cat, then you have to show these relations. Otherwise there is no way to autofill them.

Have you tried a crosstab query in Access?

Without seeing the queries that are giving you those numbers I can't tell what's happening. Can you post the SQL?

You have a many to many relation. Therefore GroupID should NOT be in your Contacts table. In your Junction table you should have an autonumber as your PK and the GroupID and ContactID fields as FKs (not PKs). Your subfrom should be bound to the junction table linked on ContactID. So it should...