Hi
I am a regular on the excel forum but this is my first delveinto access for many many yrs and stuck on one thing.
I downloaded a template issue tracker and managed to changeeverything I needed for my own use but I have a history section which saves anddate/ time stamps the comments but (and it’s annoying more than rendering thedatabase unusable) I cannot get rid of the word Version – see attachedscreenshot.
If it’s possible I’d rather have the comment prefixed withthe user name, date and time then the notes e.g. [Mfialko 07/03/2019 09:50:55]then the notes.
I assume it is something to do with this line but every timeI try to change it I end up with an error message
=ColumnHistory([RecordSource],"Comments","[ID]="& Nz([ID],0))
I have attached a screenshot of how the comments currentlysave
Than you
Reply With Quote