DATE FIELD

[Guest]

I am new to Access 2003

I created a form in which our sales people keep track of their phone
conversations with customers. Their comments are made in a "Comment / Memo"
field. They are suppose to add the date the conversation took place in this
field, but no-one seems to remember to do this. I want to add a date field
to go along with the comment field in which the current date comes up as soon
as the sales person begins to add a comment to the Memo field.

Ex: 5/12/06 Comment #1
5/13/06 Comment #2
5/17/06 Comment #3

I can do this, but the dates changes everytime you open the form on a
different day. What do I have to do to get the date field to stay the
original current date that was entered? Can someone please help me?

Aurora

 

[fredg]

I am new to Access 2003

I created a form in which our sales people keep track of their phone
conversations with customers. Their comments are made in a "Comment / Memo"
field. They are suppose to add the date the conversation took place in this
field, but no-one seems to remember to do this. I want to add a date field
to go along with the comment field in which the current date comes up as soon
as the sales person begins to add a comment to the Memo field.

Ex: 5/12/06 Comment #1
5/13/06 Comment #2
5/17/06 Comment #3

I can do this, but the dates changes everytime you open the form on a
different day. What do I have to do to get the date field to stay the
original current date that was entered? Can someone please help me?

Aurora

Why not simply add the date to the Memo field as soon as an entry is
made.

Enter your new data at the end of the memo field.
Code the Memo AfterUpdate event:

Me![MemoName] = Me![MemoName] & " " & Format(Date(),"m/d/yyyy") &
vbNewLine


When used, the memo field will look like this:
Comment #1 4/3/2006
Comment #2 4/26/2006
Comment #3 5/16/2006

If you would rather have the newer dates first, and on top, always
enter your new data at the beginning of the field.

Code the AfterUpdate event:

Me![MemoField] = Format(Date(),"m/d/yyyy") & vbNewLine &
[Me![MemoField]

5/16/2005
Comment #1
4/26/2006
Comment #2
4/3/2006
Comment #1