D
Drew Davis
If you are using an Autonumber data type, set to Increment (not Randomize),
you start with an empty table, and you first compact your database, the
values should increment (1,2,3,4,5...). You can then use a validation rule,
with the appropriate validation text to limit the number of records entered.
This, of course, assumes that you hide your tables from the users. So, they
would have to go to extraordinary lengths to get around this.
You could also put a similar validation rule in the text box of a form,
where the text box is bound to your autonumber field (this text box does not
need to be visible to the user). If you create a .mde file (or .accde in
Access 2007), then this will also help to limit the number of records. I've
heard of this as a method of limiting the use of a application made
available
as a demo only.
you start with an empty table, and you first compact your database, the
values should increment (1,2,3,4,5...). You can then use a validation rule,
with the appropriate validation text to limit the number of records entered.
This, of course, assumes that you hide your tables from the users. So, they
would have to go to extraordinary lengths to get around this.
You could also put a similar validation rule in the text box of a form,
where the text box is bound to your autonumber field (this text box does not
need to be visible to the user). If you create a .mde file (or .accde in
Access 2007), then this will also help to limit the number of records. I've
heard of this as a method of limiting the use of a application made
available
as a demo only.