Results 1 to 4 of 4
  1. #1
    salej60 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    2

    timing how long users are on each form

    guys,
    I am trying to measure the time a person is using each form. Do I use the timer or something else? Another thing I thought about is to have the start time to be the Now() function, and the end time the same but it updates when the NEXT FORM command is clicked? Then I would nee to caclulate the difference if it is possible at all. Am I on the right track? IS there something easier?

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Are the forms only open when the user is on them i.e. do they navigate to a form (the form opens) then navigate to a new form (the first close and the new form opnes)

    If so I would use VBA to datestamp (using Now()) the record on the forms open and close events'

  3. #3
    salej60 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    2

    forms

    maybe I didn,t word it correctly, the form opens once, but the user goes through the records...I think you couldn,t say that the form closes, the user only goes to the next record... So I actually need the time spent on the one record
    thanks

  4. #4
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Ok in that case you will need to add the datestamp to the event that moves to the next record.

    One way to do this would be to hide the Access Navigation buttons and create your own set that has the datestamp code on the OnClick event.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. how long
    By maintt in forum Access
    Replies: 1
    Last Post: 07-23-2010, 01:59 PM
  2. Check if form is opened by other users
    By ser01 in forum Programming
    Replies: 2
    Last Post: 05-03-2010, 12:07 AM
  3. Multiple users keying into one form......
    By softspoken in forum Forms
    Replies: 11
    Last Post: 04-13-2010, 02:18 PM
  4. Replies: 1
    Last Post: 01-04-2008, 11:40 AM
  5. how long as this been around for.?
    By SOniC in forum Access
    Replies: 0
    Last Post: 04-12-2007, 11:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums