How do I retrieve history from an append only field in Access 2007

  • Thread starter Thread starter AprilM
  • Start date Start date
A

AprilM

I have turned on the Append Only feature in Access 2007 so that my notes
field will log its history and I can essentially use my database as a CRM.
Now I want that history information to show up on a report. How do I code
the notes field to make that history show up in a separate table or memo
field with information in descending order (most recent date first) so that I
do not have to right-click the field to see its history? And where do I
place that code?
 
*Thank you* for the response. I can tell this is exactly what I'm getting at
.. . . it's unfortunately just a bit too high-level for me to grasp how I can
take this information and make it work for me in my database. I'm seeking
more simplified language and, perhaps, a guide that shows me why what code is
where so that I can look into making my own code from a very simplified
"building block" approach, if that makes sense.
 
Now I'm beginning to see the way this fits together. However, I've now
entered these expressions (where my table name Issues, column name Notes, ID
field Complaint ID):

=ColumnHistory([RecordSource],"Notes","[Complaint ID]=" & Nz([ID],0))
=ColumnHistory([RecordSource], "Notes","Complaint ID"=" & Nz([ID],0))
=ColumnHistory([RecordSource], "[Notes]","[Complaint ID]"=" & Nz([Complaint
ID],0))
=ColumnHistory([RecordSource], "Notes","Complaint ID"=" & Nz([Complaint
ID],0))
=ColumnHistory("Issues","Notes","ID=Complaint ID" = "& Nz([Complaint ID],0))

Each time I try and save the form, Microsoft Access gives me this error
message:
"The expression you entered has an invalid string. A string can be up to
2048 characters long, including opening and closing quotation marks."

Thank you for spelling this out for me, by the way!
 
Back
Top