Ms Access
-
I am creating a phonebook in c# .net my database is Ms access. There are no duplicates allowed in two columns mobile no and landline no but if I left blank those columns two times it gives an error that "no duplicates are allowed". Please give me such code to allow null but not duplicates are allowed because this is not compulsory every person has mobile or landline. thanx in advance.
-
I am creating a phonebook in c# .net my database is Ms access. There are no duplicates allowed in two columns mobile no and landline no but if I left blank those columns two times it gives an error that "no duplicates are allowed". Please give me such code to allow null but not duplicates are allowed because this is not compulsory every person has mobile or landline. thanx in advance.
-
Open the table in MS Access in the design-view, and set
Indexto "Yes (No Duplicates)". SetRequiredto "No" andAllow zero lengthto "Yes". That should do the trick :)I are troll :)
It is not working because Unique required only one null value. So I run the form first time it takes one blank column but when next time I run the form it given an error of the duplicate records.