Date/comments

[T23459]

Using Access 2000.

I have the following fields:

-ID No.
-Date/Time (General format type)
-Comments

I would like to be able to combine the Date/Time with the Comments fields:
ie when the operator starts typing a comment, the date/time (current
date/time) appears (preceding the typed text). Several comments could be
made on one particular ID number. There could be a running list of comments
for a particular ID number.
Would look something like this:

5/4/05 - 11:14am: House inspection done
6/4/05 - 13:35pm: Painting underway

Can anyone suggest a code for this.

 

[Guest]

Hi T23459,

Are you absolutely sure that you don't want to use the form / subform
approach that Dirk outlined, as a reply to your initial question? Not only
is it much easier to implement, but it's also a lot more versatile (ie. you
can run queries for comments by date, if the date value is stored in a
separate field).

If your comments can be restricted to a maximum of 255 characters, then I
strongly recommend that you consider using a text field instead of a memo
data type. This will likely be possible with the form / subform approach, but
not with the approach that you have asked about. The reason I say this is
that the memo datatype is a lot more suseptible to corruption. You will have
less headaches in the long run, if you minimize your use of memo and OLE type
fields.

Tom
__________________________________

:

Using Access 2000.

I have the following fields:

-ID No.
-Date/Time (General format type)
-Comments

I would like to be able to combine the Date/Time with the Comments fields:
ie when the operator starts typing a comment, the date/time (current
date/time) appears (preceding the typed text). Several comments could be
made on one particular ID number. There could be a running list of comments
for a particular ID number.
Would look something like this:

5/4/05 - 11:14am: House inspection done
6/4/05 - 13:35pm: Painting underway

Can anyone suggest a code for this.

 

[Rick Brandt]

Hi T23459,

Are you absolutely sure that you don't want to use the form / subform
approach that Dirk outlined, as a reply to your initial question? Not only
is it much easier to implement, but it's also a lot more versatile (ie. you
can run queries for comments by date, if the date value is stored in a
separate field).

If your comments can be restricted to a maximum of 255 characters, then I
strongly recommend that you consider using a text field instead of a memo
data type. This will likely be possible with the form / subform approach, but
not with the approach that you have asked about. The reason I say this is
that the memo datatype is a lot more suseptible to corruption. You will have
less headaches in the long run, if you minimize your use of memo and OLE type
fields.

Listen to Tom. Years ago I implemented a "Status History" in a database using
the memo field method that you are contemplating. It was a real mess after a
while. The separate table with a record per note is vastly better.