Search results

What is the best way to find duplicate records in a table with 25 columns!? I know there is a built in find duplicate query but it only allows a max of 10 columns to be compared. Edit: I actually want to find duplicates records between two tables both the same layout and columns Any help...

Thanks for the help guys, that solved my problem. Kind regards, Peter

Thanks, but how would I build that into a query?

Hello, need some help on the best way to go about validating a text field. Basically I have a main table which contains records imported from an excel file. Ideally the field should be a numeric data type but because a user could enter text in excel by accident, I would get an error when...

Finally got it to work using parts of your help. Thanks very much Rain, much appreciated. Kind regards, Peter

Ok so I did this using an append query so it puts the error files into another table. I had to use "Not "" " instead of "Is Not Null" but anyway I now want to delete those records from the main table after the append. I tried but keep getting "specify the table containing the records you want...

Hello Rain thanks for your reply but I tried that already. The only problem is, it selects the blank records in the column too. I want the blank records to stay. To give you a better understanding, I'm importing an excel file to access and doing validation checks to it. This field is a late...

Hello, this should be easy but every thing I tried isn't working or only partly working. Basically I got two tables, 1 main table with all my information and 1 with just values which are allowed in a column in the main table. In a query I want to remove records where in the particular column...

Hey Trevor, appreciate your help. appxl.ActiveWorkbook.Save appxl.Activeworbook.Close This worked a treat, I should of come here before wasted all my time looking around elsewhere. Was a really simple fix too. Kind regards, Peter

[Solved]Saving Excel file from within access Hello, I've spent hours trying to solve my problem and tried so many solutions and none have worked. Basically from within access I'm opening an excel file, editing it, then closing and saving it. It works until I get to closing and saving it...