Number of records?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to prevent the user to register more than a specified number of
records for a certain kind. Is it possible, with help of code in a form, to
test how many records there is in a table?

/ Rolf
 
Rolf Rosenquist said:
I need to prevent the user to register more than a specified number of
records for a certain kind. Is it possible, with help of code in a form, to
test how many records there is in a table?

/ Rolf
Click to expand...

Hi Rolf,
you can use DCount("FieldName", "TableName", "Condition") to know how many
records there are in a table, in BeforeUpdate event.
Bye
 
Works fine! Thank you.

/ Rolf



Cinzia said:
Hi Rolf,
you can use DCount("FieldName", "TableName", "Condition") to know how many
records there are in a table, in BeforeUpdate event.
Bye
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Access Dcount (multiple criteria) 3
Cancel insertion/delete last record 4
Lookup current record with ComboBox, any changes create new record 3
Locking records? 6
Is there a way to detect.... 7
Access Automatically Send a notification email once a record is added 0
DataMacro problem after Splitting Access Database 2010 0

Back
Top