columnhistory

  • Thread starter Thread starter Jazzmar
  • Start date Start date
J

Jazzmar

Where do I find out how to do a columnhistory. I've created a table with
fields ID, and Comments, on the Comments field I have the Append Only set to
Yes. On my form I have both fields ID, Comments and a textbox called
CommentHistory. My control source code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) for the
CommentHistory. I get a error.
 
Jazzmar said:
Where do I find out how to do a columnhistory. I've created a table with
fields ID, and Comments, on the Comments field I have the Append Only set
to
Yes. On my form I have both fields ID, Comments and a textbox called
CommentHistory. My control source code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) for the
CommentHistory. I get a error.
Click to expand...


What do you mean by "columnhistory"? Access has no built-in function of
that name. What is it that you would want to see in your CommentHistory
text box?
 
Dirk Goldgar said:
Jazzmar said:
Where do I find out how to do a columnhistory. I've created a table with
fields ID, and Comments, on the Comments field I have the Append Only set
to
Yes. On my form I have both fields ID, Comments and a textbox called
CommentHistory. My control source code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) for the
CommentHistory. I get a error.
Click to expand...


What do you mean by "columnhistory"? Access has no built-in function of
that name. What is it that you would want to see in your CommentHistory
text box?
Click to expand...

Actually, it was added in Access 2007:
http://msdn.microsoft.com/en-us/library/bb242869.aspx

That having been said, I have no experience working with the new method, so
I can't offer Jazzmar any suggestions.
 
Dirk Goldgar said:
Jazzmar said:
Where do I find out how to do a columnhistory. I've created a table with
fields ID, and Comments, on the Comments field I have the Append Only set
to
Yes. On my form I have both fields ID, Comments and a textbox called
CommentHistory. My control source code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) for the
CommentHistory. I get a error.
Click to expand...


What do you mean by "columnhistory"? Access has no built-in function of
that name. What is it that you would want to see in your CommentHistory
text box?
Click to expand...


Now that Doug has set me straight, I've done some quick testing in Access
2007. The expression you wrote is working on my test form. What error do
you get?
 
Back
Top