Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need to get Field contents based on autonumber (Access 2000)

    I am currently using a transaction log (Code By: Michael Red) to keep track of changes to records. I am posting the code here to help clarify what I am doing. This works great, except that it keeps track of the changes by the unique ID #, and I am interested in using other fields. In other words I would like to be able to view changes based on the name on the record. EXAMPLE: Index = FirstName &

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Need to get Field contents based on autonumber (Access 2000)

    This should require nothing more than a query that joins your master table with the changes table. The "link" between the tables will always be the primary key of the master table, but you can order the query by any field (or fields) in the master record.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    New Lounger
    Join Date
    Sep 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need to get Field contents based on autonumber (Access 2000)

    Mark,
    Thanks for such a quick response! I wasn't quite sure what to do to begin with, but after putting it into action IT WORKS GREAT!!!
    Thank You,
    Michael

Posting Permissions

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