I apologise if this is covered elsewhere, but i cant seem to find anything on this issue (maybe because im not sure what im looking for - im a complete novice!)
Im attempting to create a customer database for my customers which also keeps a record of when my customers contact me. This feature is implemented on the access 2013 customer call centre desktop template, which ive trid o copy to my own without success.
What i would like is a comments box where i can type a brief note of any conversation with my customer, then say press enter, te comments appears in another box with a time and date stamp. The first box becomes empty ready for the next comment etc etc
I currently have a field on my tables called 'Comments' but im not sure if i need another for the history - i cant find one on the sample database, and the ode ive used from there is this
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
But i just get an error on form view.
Ive attached an image to show what i mean.
Can anyone help? or suggest anther way i can do this?
Thanks in advance
Im attempting to create a customer database for my customers which also keeps a record of when my customers contact me. This feature is implemented on the access 2013 customer call centre desktop template, which ive trid o copy to my own without success.
What i would like is a comments box where i can type a brief note of any conversation with my customer, then say press enter, te comments appears in another box with a time and date stamp. The first box becomes empty ready for the next comment etc etc
I currently have a field on my tables called 'Comments' but im not sure if i need another for the history - i cant find one on the sample database, and the ode ive used from there is this
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
But i just get an error on form view.
Ive attached an image to show what i mean.
Can anyone help? or suggest anther way i can do this?
Thanks in advance
Comment History
0 commentaires:
Enregistrer un commentaire