Results 1 to 6 of 6
  1. #1
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209

    Table Question

    I want to add a field called dateMofied to my table, and set it as a date/time field. What I want to do is, have it capture the date/time of when the field "Book Title" is actually modified. How can I do this with my table?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    In a table, probably can't. In a form you'd use the after update event of the control containing "Book Title" and set the date field to Now().
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    Quote Originally Posted by pbaldy View Post
    In a table, probably can't. In a form you'd use the after update event of the control containing "Book Title" and set the date field to Now().
    Grr...that's what I was afraid of.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    I should have clarified that if you use a back end like SQL Server you could use a trigger, or later Access versions have data macros, which are similar (I think 2010 was the first version with data macros, but don't quote me on that).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    Quote Originally Posted by pbaldy View Post
    I should have clarified that if you use a back end like SQL Server you could use a trigger, or later Access versions have data macros, which are similar (I think 2010 was the first version with data macros, but don't quote me on that).

    How would I use a trigger? This is a linked SQL Server tale I want to do this action to.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    As far as I know it has to be set up on the server. Do you have access to it, or is there a DBA?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Lookup Table Question
    By Leonidsg in forum Database Design
    Replies: 2
    Last Post: 01-21-2013, 08:29 PM
  2. Linked Table Question
    By RayMilhon in forum SQL Server
    Replies: 2
    Last Post: 03-26-2012, 01:19 PM
  3. Question about table partitioning
    By nadergirl08 in forum Database Design
    Replies: 10
    Last Post: 01-26-2012, 07:56 PM
  4. Table relationship question
    By scoughlan in forum Database Design
    Replies: 2
    Last Post: 01-05-2012, 04:39 PM
  5. Table Relationship Question!
    By mbake085 in forum Access
    Replies: 5
    Last Post: 08-05-2010, 09:50 AM

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