Results 1 to 3 of 3

Make new record when a specific field change

  1. #1
    snhnic is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2017

    Make new record when a specific field change

    Perhaps a stupid question. I have a form used for adding new documents and change meta data of existing records. Now I want a existing record to become a new record when the version number is changed. I don't want to fill in any fields. Just the version nummer is changing, but I need it to become a new record, not to overwrite the existing record with the new value.

    file version = 00 stored with all meta data

    File version = 01 should become a new record with same metadata as 00. (just to keep all the changes)

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Looks like you need a related table to keep the version info. This table would store the document ID and a date and maybe some other info such as AuthorizedBy, etc.

    Whether a version sequence ID should be stored or calculated when needed is a separate issue.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!


  3. #3
    davegri is online now VIP
    Windows 10 Access 2016
    Join Date
    May 2012
    Add 1 to the version number and run an insert query for the new record.

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

Similar Threads

  1. Replies: 3
    Last Post: 03-12-2017, 07:29 PM
  2. Replies: 3
    Last Post: 11-28-2016, 02:17 PM
  3. Replies: 4
    Last Post: 05-18-2016, 02:32 PM
  4. How do i make a button that will go to a specific record?
    By TOMMY.MYERS668 in forum Programming
    Replies: 2
    Last Post: 02-08-2013, 06:54 AM
  5. Replies: 7
    Last Post: 11-29-2009, 12:44 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
Tech Forums: Microsoft Office Forums