records

  • Thread starter thewabit via AccessMonster.com
  • Start date
T

thewabit via AccessMonster.com

Is it possible to have a message or a flag of somesort pop up when a specific
numbered record is entered? Say I want something to happen after record # 10
is entered.

thanks
 
J

John W. Vinson

Is it possible to have a message or a flag of somesort pop up when a specific
numbered record is entered? Say I want something to happen after record # 10
is entered.

thanks
Click to expand...

What do *YOU* mean by the "record number"? Are you counting records, or
waiting for the (meaningless, arbitrary) autonumber value, or what?

Bear in mind that "record number" is not a native concept within an Access
table.
 
T

thewabit via AccessMonster.com

Maybe it would be easier to explain what I want to do. I want to analyse
every 10 ten records as a set. So I need an easy way for the end user to be
reminded when the "10th" one or "20th" one has been entered without having to
go into the table and be on the look out for it.
 
S

Steve

Put the following code in the form's AfterUpdate event:

If (DCount("*","NameOfYourTable") Mod 10) = 0 Then
MsgBox "10 Records have Now Been Entered Since Last Analysis"
End If

Steve
[email protected]
 
T

thewabit via AccessMonster.com

Thanks Steve!
Put the following code in the form's AfterUpdate event:

If (DCount("*","NameOfYourTable") Mod 10) = 0 Then
MsgBox "10 Records have Now Been Entered Since Last Analysis"
End If

Steve
[email protected]
Maybe it would be easier to explain what I want to do. I want to analyse
every 10 ten records as a set. So I need an easy way for the end user to
Click to expand...
[quoted text clipped - 16 lines]
Click to expand...
 
Top