Ok I have had a good search around the pages and I have found a lot of examples that nearly do what I want but am still having some problems.
Basically I have a DB that monitors escalations I ( and several colleagues) are dealing with, I have a memo field that requires updating with notesa and I want to place a time/date stamp in the notes first almong with the user who entered the data. This cannot overwrite original data in the memo field as I need to keep a rolling history of updates (for future reporting).
I was looking to make the updated notes field as a read only and have an update button on the main form that when clicked would open another form with a text box. Notes would be typed in and then when this for was closed it updates my main notes field with the text and the date time and user stamp.
I am hoping to get the text format as follows:
"Date/Time" "User"
" text"
I have found loads of references to date/time stamping etc but cannot get the above working
Any help would be appreciated, I have already used other bits of help and advice to get my DB up and running.
MattP
Basically I have a DB that monitors escalations I ( and several colleagues) are dealing with, I have a memo field that requires updating with notesa and I want to place a time/date stamp in the notes first almong with the user who entered the data. This cannot overwrite original data in the memo field as I need to keep a rolling history of updates (for future reporting).
I was looking to make the updated notes field as a read only and have an update button on the main form that when clicked would open another form with a text box. Notes would be typed in and then when this for was closed it updates my main notes field with the text and the date time and user stamp.
I am hoping to get the text format as follows:
"Date/Time" "User"
" text"
I have found loads of references to date/time stamping etc but cannot get the above working
Any help would be appreciated, I have already used other bits of help and advice to get my DB up and running.
MattP