time stamp

[Peter R. Fletcher]

Good Luck!

There is no way that I can conceive of in Access to link _part_ _of_
an entry in a field with another field or record in the way that you
would have to. I would have a separate Table for "Corrective Actions"
linked to your primary Table and with fields for the descriptive entry
and a date stamp (the latter defaulting to Date()). This table would
acquire a new record for each new "Corrective Action" entry, giving
you a full audit trail. It needn't look very different to what you
proposed - the new Table would appear in datasheet view in a subform
on your main form.

On Wed, 23 Jul 2003 08:34:03 -0700, "Marc" <marc.bellanca@lmco.com>
wrote:

>I am looking to place a time stamp on an entry in a
>certain field. This is what I have. I have a field
>called corrective action. In this field a number of
>different entries will be added. Is there a possible way
>to add some type of coding or anything that will show when
>the data was added when you place the cursor over the
>text. For example
>
>1) the dwg was sent to release.
>
>When you place the cursor over the line a window would pop
>up showing when the above line was added. Then you add a
>second and third etc. Each entry would have its own
>date. I want to be able to keep the old dates so that I
>can reference them when needed.

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
[url]http://www.newsfeed.com[/url] The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

[marc]

Would I then be able to bring all the entries into one
field and have them line up in order so that when it is
read the field would like one paragraph instead of a bunch
of little statements.

>-----Original Message-----
>Good Luck!
>
>There is no way that I can conceive of in Access to link

_part_ _of_

>an entry in a field with another field or record in the

way that you

>would have to. I would have a separate Table

for "Corrective Actions"

>linked to your primary Table and with fields for the

descriptive entry

>and a date stamp (the latter defaulting to Date()). This

table would

>acquire a new record for each new "Corrective Action"

entry, giving

>you a full audit trail. It needn't look very different to

what you

>proposed - the new Table would appear in datasheet view

in a subform

>on your main form.
>
>On Wed, 23 Jul 2003 08:34:03 -0700, "Marc"

<marc.bellanca@lmco.com>

>wrote:
>

>>I am looking to place a time stamp on an entry in a
>>certain field. This is what I have. I have a field
>>called corrective action. In this field a number of
>>different entries will be added. Is there a possible

way

>>to add some type of coding or anything that will show

when

>>the data was added when you place the cursor over the
>>text. For example
>>
>>1) the dwg was sent to release.
>>
>>When you place the cursor over the line a window would

pop

>>up showing when the above line was added. Then you add

a

>>second and third etc. Each entry would have its own
>>date. I want to be able to keep the old dates so that I
>>can reference them when needed.

>
>
>
>----== Posted via Newsfeed.Com - Unlimited-Uncensored-

Secure Usenet News==----

>[url]http://www.newsfeed.com[/url] The #1 Newsgroup Service in the

World! >100,000 Newsgroups

>---= 19 East/West-Coast Specialized Servers - Total

Privacy via Encryption =---

>.
>

[Peter R. Fletcher]

Only with quite a lot of coding, and you would lose (for that form)
the linkage from each individual statements to its datestamp. You
would have to write code to concatenate all the entries for each
original record and call that to create a calculated field in a query
from which you would populate the form. Why are you so set on this
very specific and restrictive way of presenting the information?


On Wed, 23 Jul 2003 10:05:37 -0700, "marc" <marc.bellanca@lmco.com>
wrote:

>Would I then be able to bring all the entries into one
>field and have them line up in order so that when it is
>read the field would like one paragraph instead of a bunch
>of little statements.
>

>>-----Original Message-----
>>Good Luck!
>>
>>There is no way that I can conceive of in Access to link

>_part_ _of_

>>an entry in a field with another field or record in the

>way that you

>>would have to. I would have a separate Table

>for "Corrective Actions"

>>linked to your primary Table and with fields for the

>descriptive entry

>>and a date stamp (the latter defaulting to Date()). This

>table would

>>acquire a new record for each new "Corrective Action"

>entry, giving

>>you a full audit trail. It needn't look very different to

>what you

>>proposed - the new Table would appear in datasheet view

>in a subform

>>on your main form.
>>
>>On Wed, 23 Jul 2003 08:34:03 -0700, "Marc"

><marc.bellanca@lmco.com>

>>wrote:
>>

>>>I am looking to place a time stamp on an entry in a
>>>certain field. This is what I have. I have a field
>>>called corrective action. In this field a number of
>>>different entries will be added. Is there a possible

>way

>>>to add some type of coding or anything that will show

>when

>>>the data was added when you place the cursor over the
>>>text. For example
>>>
>>>1) the dwg was sent to release.
>>>
>>>When you place the cursor over the line a window would

>pop

>>>up showing when the above line was added. Then you add

>a

>>>second and third etc. Each entry would have its own
>>>date. I want to be able to keep the old dates so that I
>>>can reference them when needed.

>>
>>
>>
>>----== Posted via Newsfeed.Com - Unlimited-Uncensored-

>Secure Usenet News==----

>>[url]http://www.newsfeed.com[/url] The #1 Newsgroup Service in the

>World! >100,000 Newsgroups

>>---= 19 East/West-Coast Specialized Servers - Total

>Privacy via Encryption =---

>>.
>>

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
[url]http://www.newsfeed.com[/url] The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---