Unique values field for table not working

[Guest]

Okay, this one goes into my "WTF" file:

I have a table in my database that has a part number column with an input
mask and is set as my primary key (w/ the Indexed property set to Yes (No
Duplicates)). I had a group of part numbers that I imported from an Excel
spreadsheet (imported it into a table and then wrote an append query to
populate the part number table). All of the part numbers and coresponding
information imported with no problems EXCEPT I can enter part numbers that
are identical to the ones imported. If I manually enter a part number and
then try to enter the same number, I get the appropriate warning message.
The part number format is ###.#####.###, so it's not like an issue of case
sensitivity. Anyone have any thoughts on this one? Is it possible that I
missed something while importing the data from the Excel spreadsheet?

 

[Joseph Meehan]

Okay, this one goes into my "WTF" file:

I have a table in my database that has a part number column with an
input mask and is set as my primary key (w/ the Indexed property set
to Yes (No Duplicates)). I had a group of part numbers that I
imported from an Excel spreadsheet (imported it into a table and then
wrote an append query to populate the part number table). All of the
part numbers and coresponding information imported with no problems
EXCEPT I can enter part numbers that are identical to the ones
imported. If I manually enter a part number and then try to enter
the same number, I get the appropriate warning message. The part
number format is ###.#####.###, so it's not like an issue of case
sensitivity. Anyone have any thoughts on this one? Is it possible
that I missed something while importing the data from the Excel
spreadsheet?

I wonder if in one case you may have text and another number and maybe
zero vs the letter "O" how about the difference between 12.12 and 012.12
when both may be displayed as 012.12??

 

[Brendan Reynolds]

My guess would be that the apparent duplicates are actually different in
that one includes the "." while the other only appears to include it. I
avoid input masks myself, but if you check the help file, there's a part of
the input mask that determines whether literal characters are saved with the
data or only displayed.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.