View Single Post
  #2  
Old May 27th, 2010, 10:31 PM posted to microsoft.public.access
Wayne-I-M
external usenet poster
 
Posts: 3,674
Default Primary key warning messages

Hi

You could use the indexing in the table to disallow the additions.
Or
You could could use a simple popup message

But - - -
The idea of a primary field is that it can't/shouldn't allow duplicates - so
best to use the indexing feature in the table for this (eg. Allow duplicates
= No)


--
Wayne
Manchester, England.



"Terrence Carroll" wrote:

I was wondering if it is possible to implement an error handling feature
where the user is alerted he is attempting to import duplcate values to a
primary key field while still haveing the warnings property set to NO. Any
advice on how to do this would be great.

Thanks,

Terry Carroll