Adding the date to an entry in a MEMO field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Firstly, please bear in mind that I'm using Access 97.

I have a MEMO field that users enter in comments on a particular issue. What I also want to be able to achieve is the "AUTOMATION" of a date that the user entered in the comments within this memo field.

I there a way of achieving this without the user having to do anything other than enter in the comments?
I'm new to Access as well, so please try and respond without programming code solutions!!!.

TIA
Glenn.
 
This is easily accomplished with a little "programming code", but if that's
something you don't want to do, you'll find yourself limited to only a very
small subset of Access's capabilities.

HTH
- Turtle

Glenn H said:
Hi,

Firstly, please bear in mind that I'm using Access 97.

I have a MEMO field that users enter in comments on a particular issue.
Click to expand...
What I also want to be able to achieve is the "AUTOMATION" of a date that
the user entered in the comments within this memo field.
I there a way of achieving this without the user having to do anything
Click to expand...
other than enter in the comments?
 
I don't even do that, I simply create a field in the table
and then in the form that has a default value of DATE().
Whenever a rew record is created, that seems to write the
correct value to the field. You can even hide the field
on the form.

But I do agree that you need to learn a little programming
to really do what you want to do.
Sean
-----Original Message-----
This is easily accomplished with a little "programming code", but if that's
something you don't want to do, you'll find yourself limited to only a very
small subset of Access's capabilities.

HTH
- Turtle

particular issue.
What I also want to be able to achieve is
Click to expand...
the "AUTOMATION" of a date that
 
If you want to store the date in a separate field (which will only record
the most recent edit of the comment field), you can do this:
Add a field named [LastEdited] to the table your form is based on.
In the AfterUpdate event of your comments textbox, add this code:
LastEdited=Now()
(This will store the date and time of the last edit. If you just want the
date, use Date() instead of Now().)

Here's how to find the place to put this code:
With your form in Design View, display the property window for your
comments textbox.
Find the row marked AfterUpdate. Click on it.
From the dropbox, select [Event Procedure].
Now click on the 3 dots at the end of the row.
A code window will open; the cursor will be exactly where you need to
insert the code above.

HTH
- Turtle
 
Hi,

Firstly, please bear in mind that I'm using Access 97.

I have a MEMO field that users enter in comments on a particular issue. What I also want to be able to achieve is the "AUTOMATION" of a date that the user entered in the comments within this memo field.

I there a way of achieving this without the user having to do anything other than enter in the comments?
I'm new to Access as well, so please try and respond without programming code solutions!!!.
Click to expand...

Well, I have to agree with McDermott. You have blocked the only viable
answer to the question AS POSED before we have a chance to answer; in
order to put the date in a memo field you must - no option - use VBA
code, Access simply can't do it without it.

HOWEVER - storing multiple separate comments in a single memo field is
probably a flawed table design. You might want to consider having a
Comments table with four fields: an autonumber Primary Key; a foreign
key linked to the primary key of your main table; a CommentDate field
with a default property of Date(); and a Text field (or Memo field, if
individual comments sometimes exceed 255 bytes) for the comment. You
can use a Subform to enter the comments and they'll datestamp
themselves with no code and no effort.
 
Back
Top