Results 1 to 2 of 2
  1. #1
    shanethomp is offline Novice
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    1

    Help with Adding Time Stamp to Contact

    I am trying to add a time stamp so that every time a contact is made it records the time that it was made. however it is just showing the word BINARY instead of the time.



    Any help woudl be appreciated.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    Can't see the attachment well enough - sorry.

    In general the way to do this is have a field in the table; set it to be a date/time data type, select the format that you want. Then in the default value property - which is by default blank - put in: =Now() if you want time - or - =Date() if you just want date.

    Hope this helps.

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

Similar Threads

  1. Append Query: Time Stamp
    By AKQTS in forum Programming
    Replies: 3
    Last Post: 08-16-2010, 12:34 PM
  2. Question about Button and Time Stamp
    By euroclyde in forum Access
    Replies: 2
    Last Post: 06-16-2010, 09:01 AM
  3. Time Stamp Removal/deletion?
    By thorsonb in forum Access
    Replies: 3
    Last Post: 03-30-2010, 10:17 PM
  4. Replies: 4
    Last Post: 01-30-2010, 05:22 PM
  5. Replies: 0
    Last Post: 06-19-2007, 09:45 AM

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
  •  
Other Forums: Microsoft Office Forums