Run Find Duplicates wizard from code?

[jwhjr]

Does anyone out there know how to run the Find Duplicates wizard from code? I am using Access 2003 and have found how to run most of the other wizards from code at the following link:

http://www.mvps.org/access/general/gen0028.htm

It doesn't reference the duplicates one, and I can't find the name for the duplicates wizard anywhere. Any help would be appreciated.

JR

 

[vbajock]

I don't know what you are trying to present to the user, but you can run a "find duplicates" SQL from code that will acheive the same ends.

 

[jwhjr]

It's actually for me to use, I have a large number of tables in multiple databases that I have to look for duplicate data in. To make a long story short, I can only get the wizards to run from code, they will not run the conventional way. I have tried all of the suggested methods to make sure that all of the proper files are where they should be, reinstalling Access etc. with no luck. They work fine from code though. I like the ease of the wizard and do not want to have to modify SQL for each of the tables if at all possible.