If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
records
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/For...esign/201002/1 |
#3
|
|||
|
|||
records
On Sun, 07 Feb 2010 20:19:48 GMT, "thewabit via AccessMonster.com"
u57141@uwe 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
records
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
records
Thanks Steve!
Steve wrote: 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 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] Bear in mind that "record number" is not a native concept within an Access table. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|