Unanswered: Allow limited duplicate values in access table field
I want to limit the values like numbers or text in one record field of ms access table. say i want to allow value <1234> entered only up to 10 times in the record field, if entered 10 times more it will indicate that the value entered in all records of particular filed is more than required nos ie 10.
Thanks for reply..
but there may be some way like some code in VBA or through query or form... i want to restrict/limit the "n" number of same value entered in field.
Pl help me to find the solution..
Thanks & regards..
for a=0 to ubound(dup)
if dup(a)>1 then
do the dup thing
Last edited by myle; 10-11-16 at 15:46.
Reason: spelling ,gramma
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.