| | |
|
|
|
HOW TO LIMITATE NUMBER OF THE RECORDS IN A TABLE ? |
|---|
| message from Chris on 11 May 2004 |
I need to limitate the number or the records introduced by a certain user
in
a table at a time ( let's say to 7) . Can it be done? How?
P.S. This is a temporary table, from which I am moving the records in
another one, and I need to print a report before moving them, containing
at most 7 records (a standardized one). The record are introduced using
a
form and saved with a cmd. button. I want not to alloud them to add the
eighth record.
Thank you!
|
| Allen Browne replied to Chris on 11 May 2004 |
Private Sub Form_BeforeInsert(Cancel As Integer)
If DCount("*", "NameOfYourTableHere") > 7 Then
Cancel = True
MsgBox "No more records!"
End If
End Sub
|
| Allen Browne replied to Chris on 11 May 2004 |
Answered the the other group you posted this to.
|
|
Archived message: HOW TO LIMITATE NUMBER OF THE RECORDS IN A TABLE ? (Microsoft Access Database)
