Results 1 to 2 of 2
  1. #1
    baovue is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2019
    Posts
    1

    Import data in a ColumnHistory

    Hi All!

    I have a comment history field that shows the history of the comments. Is there a way for me to export all of that information for all records? I've only found methods for just one record and I need for all records.

    Thank you!!!

  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
    If you are using the column history property of memo fields, its a bit tricky as that feature uses deep hidden system tables.
    However if you read this article on my website, it should help you http://www.mendipdatasystems.co.uk/c...lds/4594523656
    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

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

Similar Threads

  1. How can I import ColumnHistory into a new Access shell?
    By tgall in forum Import/Export Data
    Replies: 6
    Last Post: 01-25-2019, 07:36 AM
  2. ColumnHistory in a form
    By JeRz in forum Forms
    Replies: 2
    Last Post: 12-12-2016, 02:43 PM
  3. Replies: 13
    Last Post: 01-25-2016, 01:36 PM
  4. ColumnHistory
    By kdf in forum Programming
    Replies: 1
    Last Post: 03-27-2014, 01:34 PM
  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