DataBase - records

Asked By thewabit via AccessMonster.com

07-Feb-10 08:19 PM

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1

07-Feb-10 03:40 PM

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

Steve
santus@penn.com

07-Feb-10 05:22 PM

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

John W. Vinson [MVP]

08-Feb-10 05:16 AM

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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1

08-Feb-10 10:58 AM

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
santus@penn.com

09-Feb-10 12:46 AM

Thanks Steve!


--
Message posted via http://www.accessmonster.com