Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update based on Modifications (Access 2000 SR-1)

    Information gathering:

    I have a database with a COST and a Comments Column

    I would like some suggestions on updating a field when changes are made in any of these fields. IF a Comment was updated, then a ' * ' is placed in the Changes Field. If a COST was updated, then a ' $ ' is placed. If both, then ' *$ '.

    Thanks

    Paul

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Update based on Modifications (Access 2000 SR-1)

    To do that sort of thing you will need to use a form - editing at the table level doesn't trigger events. On a form you can use the AfterUpdate event for a text box to determine if a field has changed - that isn't entirely foolproof though, as a user may make a change and then undo it. Probably a better approach would be to use the OldValue property of bound controls to determine in code if either or both have changed. That would best be triggered with the BeforeUpdate event for the form. You might also look at capturing the date and time of the most recent change, and the user name who made the change, assuming you have user security activated.
    Wendell

Posting Permissions

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