Results 1 to 4 of 4

Thread: MS Access Forms

  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Question Unanswered: MS Access Forms

    I am not very good with vb in access and was wondering if anyone could help me!

    I am using access 2000.

    I have created a form with several buttons that call stored queries and other forms. What I am trying to do is when a user clicks a button in a form I want to capture the time the button was clicked, the time the process ended and time it took to complete. I need to store this information in a table.

    Can anyone please help me with any part of this?

    Any help at all would be appreciated.

    Thanks in advance,
    Marin

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Docmd.RunSQL "INSERT INTO MyLogTable (MyTimeStamp) VALUES (#" & Now & "#);"

  3. #3
    Join Date
    Feb 2004
    Posts
    3

    Talking

    Thank you very much! It worked

  4. #4
    Join Date
    Feb 2004
    Posts
    3
    Anyone have a way or a suggestion on how to get total time spent to process?

    Thanks in advance,
    Marin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •