number of record restrictions

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Is there any way I can restrict the number of records in a table?

I have a table in which I have set up six codes (payment terms for billing),
I need to allow the user to edit the values in these six records but I don't
want them to create any more.

I don't know if this is possible but if anyone can advise me on it I would
really appreciate the help.

Thanks

Jean
 
Jean said:
Is there any way I can restrict the number of records in a table?

I have a table in which I have set up six codes (payment terms for
billing), I need to allow the user to edit the values in these six
records but I don't want them to create any more.

I don't know if this is possible but if anyone can advise me on it I
would really appreciate the help.
Click to expand...

A possible way could be a table-validation-rule if you have a
primaryKey field as auto-value.
(Name could be 'ID')

validation rule: [ID]<=6
validation-text: Only 6 Records allowed in this Table!

If there are already records with ID=1...ID=6 it's not
possible to add new records.

Acki
 
Thanks for this, I have drained myself for today - but I will do this
tomorrow and it should save me some worries about user error.

Jean

Joerg Ackermann said:
Jean said:
Is there any way I can restrict the number of records in a table?

I have a table in which I have set up six codes (payment terms for
billing), I need to allow the user to edit the values in these six
records but I don't want them to create any more.

I don't know if this is possible but if anyone can advise me on it I
would really appreciate the help.
Click to expand...

A possible way could be a table-validation-rule if you have a
primaryKey field as auto-value.
(Name could be 'ID')

validation rule: [ID]<=6
validation-text: Only 6 Records allowed in this Table!

If there are already records with ID=1...ID=6 it's not
possible to add new records.

Acki
Click to expand...
 
Don't allow the user to do data entry / edit directly on the Table. Simply
create a Form for editing by setting the "AllowAdditions" Property to No /
False.
 
Back
Top