Results 1 to 4 of 4
  1. 12-10-2012, 03:04 PM #1
    jezza9371
    jezza9371 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    2

    Date/Time Stamp when record in form is viewed.

    I know how to automate Date/Time stamp when a record is updated, but is there a way to do it just when the record is viewed in a form?
    Reply With Quote Reply With Quote
  2. 12-10-2012, 03:18 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You would get a CurrentEvent what that happens.
    Reply With Quote Reply With Quote
  3. 12-10-2012, 03:23 PM #3
    jezza9371
    jezza9371 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    2
    I figured it might be a CurrentEvent. How would you code it?
    Reply With Quote Reply With Quote
  4. 12-10-2012, 05:14 PM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The same way you would code it in say the BeforeUpdate event. Me!DateField = Date()
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Adding a Time Stamp to a Form
    By Tomlon in forum Forms
    Replies: 2
    Last Post: 02-03-2012, 08:45 AM
  2. Date and Time Stamp
    By zoooza84 in forum Access
    Replies: 2
    Last Post: 08-06-2011, 04:53 AM
  3. Record Time Stamp when Click New Record Command button
    By jlclark4 in forum Forms
    Replies: 4
    Last Post: 07-22-2011, 12:52 PM
  4. Date/Time Stamp when the tables are imported
    By ragsgold in forum Forms
    Replies: 4
    Last Post: 01-30-2010, 05:22 PM
  5. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums