Article View: comp.databases.ms-access
Article #188Re: How can I limit the number of records in a table? (MS Access)
From: Scott Mordecai
Date: Wed, 06 May 1998 00:00
Date: Wed, 06 May 1998 00:00
22 lines
1497 bytes
1497 bytes
>Sub Form_BeforeInsert > ^^^^ > Clue #1 > >Sub Form_BeforeInsert > ^^^^^^^^^^^^ > Clue #2 Clue #3 - if I'd had more than five seconds to learn Access and produce an application I wouldn't have had to ask! (The last time I wrote an application dBase III was *the* database to use!) By the way, one of the suggestions here works a treat, the other gives an error (the "Dcount" version), probably me just not understanding the command and therefore not typing it in properly. Thanks to all, -- \|||/ Scott Mordecai < o,o > mailto:scott@musicman.demon.co.uk \_/
Technical Details
Message-ID:
<ZEKgkKAEJNU1Ew$K@musicman.demon.co.uk>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<cUehgLAJMNT1Ewmx@musicman.demon.co.uk> <35640a0b.6616746@news.easynet.co.uk> <WG9DUHAFFfT1Ewnt@musicman.demon.co.uk> <35506df6.477360@news.easynet.co.uk>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 1036bc,d87e857d2b30eade X-Google-Attributes: gid1036bc,public X-Google-Thread: ff0ac,d87e857d2b30eade X-Google-Attributes: gidff0ac,public From: Scott Mordecai <Scott@musicman.demon.co.uk> Subject: Re: How can I limit the number of records in a table? (MS Access) Date: 1998/05/06 Message-ID: <ZEKgkKAEJNU1Ew$K@musicman.demon.co.uk> X-Deja-AN: 350898083 References: <cUehgLAJMNT1Ewmx@musicman.demon.co.uk> <35640a0b.6616746@news.easynet.co.uk> <WG9DUHAFFfT1Ewnt@musicman.demon.co.uk> <35506df6.477360@news.easynet.co.uk> MIME-Version: 1.0 X-NNTP-Posting-Host: musicman.demon.co.uk:158.152.20.171 X-Complaints-To: abuse@demon.net X-Trace: news.demon.co.uk 894489507 nnrp-04:10552 NO-IDENT musicman.demon.co.uk:158.152.20.171 Organization: Anywhere Newsgroups: comp.databases.ms-access,demon.tech.pc