Consulting

Results 1 to 3 of 3

Thread: Prefixing a note with user name / date & time

  1. #1
    VBAX Contributor
    Joined
    Jul 2011
    Location
    Manchester
    Posts
    142
    Location

    Prefixing a note with user name / date & time

    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







    Attached Files Attached Files

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    You do not actually say where this takes place.
    Is it in the Control Surce of the History Field?
    How does the user enter the "comment"?
    How are you estbalishing the User?

  3. #3
    My advice would be to redesign this part of the application and use your own table for these comments containing user name, date of writing and the actual comment as separate columns. You can then format the history in any way you like.
    Learn VBA from the ground up with my VBA Online Courses.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •