Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Location
    Chicago area
    Posts
    4

    Unanswered: Need Time Only upon record creation

    I need a way to enter a time only timestamp when a record is created.

    Thank you in advance for any help.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    A 'Time only' TimeStamp is kind of odd, but
    Code:
    Private Sub Form_BeforeUpdate(Cancel As Integer)
     If Me.NewRecord Then
       Me.TimeStampField = Time()
     End If
    End Sub
    Linq ;0)>
    Last edited by Missinglinq; 07-02-11 at 12:23.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

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