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

Article View: comp.databases.ms-access

Article #191

Back to comp.databases.ms-access Previous Next

#191

From: Scott Mordecai
Date: Sun, 03 May 1998 00:00

17 lines
1287 bytes

Hi, I hope I can make some sense here...

I have a form which has basic record details (person's name, telephone
number, etc.). On this form is a datasheet sub-form where I can list a
number of items. I would like to limit the number of entries on this
datasheet.

e.g. the datasheet has two fields, "Name" (linked to the main record
table) and "Item". I would like each "Name" to be allowed only a maximum
number of items.

Any help, if the above makes any sense, is appreciated!
-- 
 \|||/  Scott Mordecai
< o,o > mailto:scott@musicman.demon.co.uk
  \_/

Technical Details

Message-ID: <cUehgLAJMNT1Ewmx@musicman.demon.co.uk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1036bc,d87e857d2b30eade,start
X-Google-Attributes: gid1036bc,public
X-Google-Thread: ff0ac,d87e857d2b30eade,start
X-Google-Attributes: gidff0ac,public
From: Scott Mordecai <Scott@musicman.demon.co.uk>
Subject: How can I limit the number of records in a table? (MS Access)
Date: 1998/05/03
Message-ID: <cUehgLAJMNT1Ewmx@musicman.demon.co.uk>
X-Deja-AN: 349903070
X-NNTP-Posting-Host: musicman.demon.co.uk:158.152.20.171
X-Complaints-To: abuse@demon.net
X-Trace: news.demon.co.uk 894227252 nnrp-06:27294 NO-IDENT musicman.demon.co.uk:158.152.20.171
Organization: Anywhere
MIME-Version: 1.0
Newsgroups: comp.databases.ms-access,demon.tech.pc