Mantispony
Registered User.
- Local time
- Today, 01:48
- Joined
- Mar 31, 2011
- Messages
- 15
Hi all,
you guys (and girls?) have been incredibly helpful so far, so I'm not hesitating to ask yet another question
I know about the ColumnHistory function, but apparently it only displays the ColumnHistory for one particular record (as programmed in the function).
..at least that's what it's doing for me, if and when it works at all.
The function I'm using is:
=ColumnHistory([RecordSource],"Comments","[contact_ID]=" & Nz([contact_ID],0))
modified to mirror my database:
=ColumnHistory([Tabel1],"Commentaar","[ID]=1" & Nz([contact_ID],0))
That doesn't do a lot. I only get an error message saying I made an error in the function spelling..
So I tried removing the ID nr:
=ColumnHistory([Tabel1],"Commentaar","[ID]=" & Nz([contact_ID],0))
..which gave me the exact same result: the same error message.
However, it seems to work for everyone else. What am I doing wrong?
Also, I'd like it to display the history in a form, per record.
Thanks!!
you guys (and girls?) have been incredibly helpful so far, so I'm not hesitating to ask yet another question
I know about the ColumnHistory function, but apparently it only displays the ColumnHistory for one particular record (as programmed in the function).
..at least that's what it's doing for me, if and when it works at all.
The function I'm using is:
=ColumnHistory([RecordSource],"Comments","[contact_ID]=" & Nz([contact_ID],0))
modified to mirror my database:
=ColumnHistory([Tabel1],"Commentaar","[ID]=1" & Nz([contact_ID],0))
That doesn't do a lot. I only get an error message saying I made an error in the function spelling..
So I tried removing the ID nr:
=ColumnHistory([Tabel1],"Commentaar","[ID]=" & Nz([contact_ID],0))
..which gave me the exact same result: the same error message.
However, it seems to work for everyone else. What am I doing wrong?
Also, I'd like it to display the history in a form, per record.
Thanks!!
Last edited: