records

[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

 

[Steve]

Look at the MsgBox function in the Help file. Use it in your form's
AfterUpdate event.

Steve
(e-mail address removed)

 

[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

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.

 

[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.

 

[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
(e-mail address removed)

 

[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
(e-mail address removed)

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

[quoted text clipped - 16 lines]