Results 1 to 3 of 3
  1. #1
    Rwathen10 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    13

    Cool Memo Field- Pop up that shows dates when changes were made

    Hello, I once saw a video online of a Memo field showing the times in which changes had been made to it. I cannot for the life of me remember how the instructor did and Google searches have not helped.



    I believe the instructor pressed a few keys when his mouse hovered over the Memo field and a pop-up with dates came up. I do not believe he used VBA.

    I have a table linked to a form where I am able to change the values of my “Comments” field in my Source Table. I want to be able to see when changes were made (ie, new comments were added to my “Comments” field)

    Do any of you guys know what I am talking about?

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,842
    in the table design, you need to change the memo field Append Only property to yes.

    see this link for more information

    http://blogs.msdn.com/b/thirdoffive/...01/684354.aspx

  3. #3
    Rwathen10 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    13
    Exactly what I was looking for, Ajax. Humans are so much better at providing answers to searches than algorithms (for now).

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

Similar Threads

  1. Replies: 9
    Last Post: 07-21-2014, 11:57 AM
  2. VBA dates on a form made from a query
    By sdel_nevo in forum Programming
    Replies: 8
    Last Post: 02-06-2014, 11:56 AM
  3. Replies: 5
    Last Post: 10-14-2013, 11:53 AM
  4. Query that shows dates near today
    By LukeJ Innov in forum Queries
    Replies: 2
    Last Post: 09-03-2013, 04:57 AM
  5. Date field that shows only related dates
    By kelkan in forum Access
    Replies: 1
    Last Post: 01-27-2013, 04:00 PM

Tags for this Thread

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