Re: Force a limit to number of rows

Rich

If you are working directly in the table (not a good idea in Access),
Jamie's approach will serve (and in fact, would server no matter how your
users were entering data). It requires a bit more technical approach and,
as Jamie mentions, is not supported or documented, so you (or your
successor) may have trouble figuring out what was done.

Another approach, perhaps less technical, but perhaps more "discoverable",
would be to use a form to mediate data entry (this is the preferred method).
Then, in the form's BeforeInsert event, you could create a procedure that
does what Jamie described, count the number of existing records.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Rich K" <RichK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DFAEEA61-17E7-48D3-A8EE-E28AEF2A3C32@xxxxxxxxxxxxxxxx
I want to limit the number of rows in a table for demonstration purposes.
I
seem to recall that this can be done in the advanced properties of the
table
in the validation Rule but I can't recall the syntax. Can anybody share a
hint on how this is done?


.

Relevant Pages

  • Re: class A amplifier
    ... Jamie wrote: ... I don't recall ever having seen one, ... Oh there's plenty original (and some interesting variants on established concepts like> using ... If frogs had wings... ...
    (sci.electronics.basics)
  • Re: class A amplifier
    ... Jamie wrote: ... I don't recall ever having seen one, ... Oh there's plenty original (and some interesting variants on established concepts like> using ... If Studiomaster hadn't shut down free public access to their schematics you could see loads of ...
    (sci.electronics.basics)