Anthony: Duplicates

Resolved · Low Priority · Version 2007

Wed 25 Jan 2012, 16:43 Delegate Alain said...

Alain has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Introduction to Management course

Anthony: Duplicates

Hi Anthony,

Could you please send us a procedure that we could use to remove duplicates contained in a database?

I am not only interested in finding duplicates. I also would like to be able to remove the relevant records.

I thank you in advance for your help.

Alain

Fri 27 Jan 2012, 07:15 Trainer Anthony said...

RE: Anthony: Duplicates

Hi Alain, good to hear from you again. Here is Microsoft's advice on dealing with duplicates in your database:

http://office.microsoft.com/en-us/access-help/find-eliminate-or-hide-duplicate-records-in-access-HA001034558.aspx

...and here is a real-world example which shows you the sort of hoops you'll have to jump through:

http://dailycupoftech.com/2009/03/29/remove-duplicate-records-in-access/

Hope this helps,

Anthony

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips