Results 1 to 4 of 4

Thread: Is it Possible

  1. #1
    Join Date
    Feb 2004
    Location
    Vermont
    Posts
    53

    Question Unanswered: Is it Possible

    In Access is it possible in a table that each time some one makes a change anywhere in the table it makes a new record, and how do I accomplish this.

    Thanks for helping,

    CAT
    CAT :-D

  2. #2
    Join Date
    Nov 2003
    Location
    LONDON
    Posts
    238
    There are no triggers as there is in SQL Server in Access.

    The best way to do this is in the BeforeUpdate event of the form that the user is using to change a record. You can see what the user is changing, including the original value and the new value they are entering.

    Justin

  3. #3
    Join Date
    Feb 2004
    Location
    Vermont
    Posts
    53
    But will this create a new record by using this method?
    CAT :-D

  4. #4
    Join Date
    Nov 2003
    Location
    LONDON
    Posts
    238
    Yes if you want it to. You obviously have to put the relevant code into the event to make this happen such as a Docmd.RunSQL function or use ADO/DAO in the event to add a record. See help for the details
    Justin

Posting Permissions

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