How to limit the number of records??

[seafmmu]

hai all, I have a situation here. For a database for voice mail, I want to limit the number of messages to be recorded for each account. Is is possible to do so with Ms Access. If it is possible, can you all out there lend me a helping hand?

 

[KenReay]

Hi

If You are in a form and the messages table is bound to it and limited to the account:

Me.RecordsetClone.MoveLast
If Me.recordsetClone.RecordCount > YourMaxNumber Then
msgbox "Too Many ....
End If

or

Dim Db AS Database
Dim Rs As DAO.Recordset
Dim strSQL as String
'
strSQL = "SELECT * FROM tblMessages WHere Account = '" & TheAccountInHere & "';"
Set Db = CurrentDb()
Set Rs = Db.OpenRecordset(strSQL)
If Rs.Recordcount > YourMAaxNumberHere THEN
msgbox "Too many"
Else
......
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use