Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: Time Stamp a Form name

    Hi, There is a way I can timestamp a form name. For example, tracking which form was opened. I am able to timestamp time/date entered/exited into a form but Idon't know how to get a name.

    thanks
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    Me.Form.Name would do the trick.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Are you storing this information in a table somwhere?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113
    Yes, in a table.
    ======================
    Levent
    Access 3

  5. #5
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113
    I am getting a method or data member not found on that

    Code:
     ' Open the session table on the server
        Set rst = db.OpenRecordset("tblLog", dbOpenDynaset, dbSeeChanges)
        With rst
            ' Add a new record
            .AddNew
            ' Log in the user on the server
            !SessionID = dblSessionNo
            !EmployeeID = CurrentID()
            !FormName = !me.Form.Name
            !Login = Now
          !LastUpdate = Now
    .Update

    End With
    ======================
    Levent
    Access 3

  6. #6
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113
    Never mind, it works I had the ! in front of me.form.name
    Thanks Terp
    ======================
    Levent
    Access 3

Posting Permissions

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