J Jim Z. Jan 7, 2004 #1 I would like to make a sample database that limits the amount of entries. How can this be acomplished.
I would like to make a sample database that limits the amount of entries. How can this be acomplished.
J Jeff Conrad Jan 7, 2004 #2 Hi, See if this link on Tony Toews' site helps: http://www.granite.ab.ca/access/demo.htm It's WAY beyond my experience level, but hopefully it will get you going in the right direction. Good luck, Jeff Conrad Bend, Oregon
Hi, See if this link on Tony Toews' site helps: http://www.granite.ab.ca/access/demo.htm It's WAY beyond my experience level, but hopefully it will get you going in the right direction. Good luck, Jeff Conrad Bend, Oregon
J John Vinson Jan 7, 2004 #3 I would like to make a sample database that limits the amount of entries. How can this be acomplished. Click to expand... One sneaky way is to have an Autonumber or (Long) Integer primary key with a validation rule 0 AND <= 100 Click to expand... to limit the table to 100 entries. Of course you need to ensure that the user can't open the table in design view and change the rule!
I would like to make a sample database that limits the amount of entries. How can this be acomplished. Click to expand... One sneaky way is to have an Autonumber or (Long) Integer primary key with a validation rule 0 AND <= 100 Click to expand... to limit the table to 100 entries. Of course you need to ensure that the user can't open the table in design view and change the rule!
J Jeff Conrad Jan 7, 2004 #4 Well hey, even "I" could do that! Thanks for the tip John, I might use this. Jeff Conrad Bend, Oregon
Well hey, even "I" could do that! Thanks for the tip John, I might use this. Jeff Conrad Bend, Oregon
