🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #190

Re: How can I limit the number of records in a table? (MS Access)

#190
From: Dev Ashish
Date: Mon, 04 May 1998 00:00
25 lines
1318 bytes
Try entering the code in the subform's On Current event and modifying the
field names accordingly.

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

Scott Mordecai wrote in message ...
>>You hanve't mentioned the Access version.  But something like this should
>>work under 97.
>>
>>Private Sub Form_Current()
>
>Thanks for the reply. I would love to try your little peice of code, but
>I don't know exactly where I should enter it. :( Can you help?
>
>Cheers,
>--
> \|||/  Scott Mordecai
>< o,o > mailto:scott@musicman.demon.co.uk
>  \_/
Technical Details
Message-ID: <6il89d$agj@bgtnsc03.worldnet.att.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <cUehgLAJMNT1Ewmx@musicman.demon.co.uk><6iitlc$c3p@bgtnsc03.worldnet.att.net> <RWCCgAA4DfT1Ewnf@musicman.demon.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: "Dev Ashish" <dash10@hotmail.com>
Subject: Re: How can I limit the number of records in a table? (MS Access)
Date: 1998/05/04
Message-ID: <6il89d$agj@bgtnsc03.worldnet.att.net>
X-Deja-AN: 350222239
References: <cUehgLAJMNT1Ewmx@musicman.demon.co.uk><6iitlc$c3p@bgtnsc03.worldnet.att.net> <RWCCgAA4DfT1Ewnf@musicman.demon.co.uk>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: AT&T WorldNet Services
Newsgroups: comp.databases.ms-access,demon.tech.pc