Results 1 to 4 of 4
  1. #1
    JeRz is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    33

    Alternative solution to ColumnHistory?

    Hi everyone,

    I have a database that tracks customer issues. All issue notes are stored in a Notes table.





    Issuenotes
    IssuenoteID-PK
    EntryDate
    EnteredBy
    IssueNote
    IssueID FK


    I'm trying to think ahead of a possible user request. For example, if I go to issue 50 and it has 5 notes, they will currently show in a continuous form in chronological order with the date entered and who entered the note.


    Is there a way to do something like ColumnHistory into a text box or similar that combines all the Notes from a issue into a "snapshot" type view? I can see folks wanting to pull this data into Excel and wanting an overall view.


    Thanks for any help!

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You could loop through each record and build up a lengthy text string but
    - it will make searching difficult
    - eventually you may hit a character limit

    I wouldn't do it myself.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    JeRz is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    33
    Okay, thanks!

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    I agree with Colin, if you're talking about doing this in a Form.

    You could, of course, use the method he suggested in a Report...and I suppose you could then insert the Report in a Form.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. ColumnHistory in a form
    By JeRz in forum Forms
    Replies: 2
    Last Post: 12-12-2016, 02:43 PM
  2. ColumnHistory with multiple columnnames
    By Nadine67 in forum Access
    Replies: 4
    Last Post: 07-20-2015, 03:37 PM
  3. ColumnHistory
    By kdf in forum Programming
    Replies: 1
    Last Post: 03-27-2014, 01:34 PM
  4. ColumnHistory Code
    By huv123 in forum Programming
    Replies: 2
    Last Post: 02-18-2011, 03:41 AM
  5. =columnhistory
    By botts121 in forum Programming
    Replies: 1
    Last Post: 07-06-2009, 07:26 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
  •  
Other Forums: Microsoft Office Forums