Time spent on MSAccess record "joker" <sope[ at ]microsoft.com> 12/31/2008 3:50:11 PM How do I measure the time a user spends on a particular MSAccess 2003 record? regards johnb

Re: Time spent on MSAccess record Bob I <birelan[ at ]yahoo.com> 12/31/2008 3:58:50 PM That may be quite a bit of coding. maybe stand behind the user with a stopwatch. joker wrote: [Quoted Text] > How do I measure the time a user spends on a particular MSAccess 2003 > record? > > regards > johnb > > >

Re: Time spent on MSAccess record "Beth Melton" <bmelton[ at ]mvps.org> 12/31/2008 5:18:55 PM "joker" <sope[ at ]microsoft.com> wrote in message news:OsTw391aJHA.4068[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] > How do I measure the time a user spends on a particular MSAccess 2003 > record? I suppose you could use a couple event procedures (probably OnDirty and AfterUpdate) to start and stop a timer (you could use GetTickCount API although it's not 100% accurate) and then whatever you want to do with the recorded time such as show it in a message box or Write a record in a table. Perhaps post in one of the Access newsgroups -- someone may already have example code for something like this. -- ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP https://mvp.support.microsoft.com/profile/Melton What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs Guides for the Office 2007 Interface: http://office.microsoft.com/en-us/training/HA102295841033.aspx