Thread
:
records
View Single Post
#
5
February 8th, 2010, 03:58 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
Posts: 1,017
records
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
"thewabit via AccessMonster.com" u57141@uwe wrote in message
news:a34f819d2acbe@uwe...
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.
John W. Vinson wrote:
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.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]