Can I add a date stamp (and or a User stamp) in a Text or Memo Field when a
user updates my notes field (Memo)

If you are asking, "can I concatenate the value of the current date and time
into a text field's contents" (or memo field's contents), the answer is yes.

--

Ken Snell
<MS ACCESS MVP>

"Michael L" <Michael (E-Mail Removed)> wrote in message
news:678C3394-E594-45A7-A489-(E-Mail Removed)...
> Can I add a date stamp (and or a User stamp) in a Text or Memo Field when
> a
> user updates my notes field (Memo)

Can you point me in the dircection of any examples or code that could help
me. Thanks,

"Ken Snell [MVP]" wrote:

> If you are asking, "can I concatenate the value of the current date and time
> into a text field's contents" (or memo field's contents), the answer is yes.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Michael L" <Michael (E-Mail Removed)> wrote in message
> news:678C3394-E594-45A7-A489-(E-Mail Removed)...
> > Can I add a date stamp (and or a User stamp) in a Text or Memo Field when
> > a
> > user updates my notes field (Memo)
>
>
>

In which context would you be doing this?

As an example, the following code step would add the current date and time
to a control on a form:

Me.ControlName.Value = Me.ControlName.Value & vbCrLf & _
Format(Now(), "dd mmm yyyy at hh:nn:ss ampm")

--

Ken Snell
<MS ACCESS MVP>

"Michael L" <(E-Mail Removed)> wrote in message
news:C39D5763-B932-486F-AE5C-(E-Mail Removed)...
> Can you point me in the dircection of any examples or code that could
> help
> me. Thanks,
>
> "Ken Snell [MVP]" wrote:
>
>> If you are asking, "can I concatenate the value of the current date and
>> time
>> into a text field's contents" (or memo field's contents), the answer is
>> yes.
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "Michael L" <Michael (E-Mail Removed)> wrote in message
>> news:678C3394-E594-45A7-A489-(E-Mail Removed)...
>> > Can I add a date stamp (and or a User stamp) in a Text or Memo Field
>> > when
>> > a
>> > user updates my notes field (Memo)
>>
>>
>>

Note that the vbCrLf that I put in the code is not a requirement - I
included it only as a "separator" for the date/time stamp. Also, the Format
"format" ("dd mmm yyyy at hh:nn:ss ampm") that I provided can be changed to
other options.
--

Ken Snell
<MS ACCESS MVP>

"Ken Snell [MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> In which context would you be doing this?
>
> As an example, the following code step would add the current date and time
> to a control on a form:
>
> Me.ControlName.Value = Me.ControlName.Value & vbCrLf & _
> Format(Now(), "dd mmm yyyy at hh:nn:ss ampm")
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Michael L" <(E-Mail Removed)> wrote in message
> news:C39D5763-B932-486F-AE5C-(E-Mail Removed)...
>> Can you point me in the dircection of any examples or code that could
>> help
>> me. Thanks,
>>
>> "Ken Snell [MVP]" wrote:
>>
>>> If you are asking, "can I concatenate the value of the current date and
>>> time
>>> into a text field's contents" (or memo field's contents), the answer is
>>> yes.
>>>
>>> --
>>>
>>> Ken Snell
>>> <MS ACCESS MVP>
>>>
>>> "Michael L" <Michael (E-Mail Removed)> wrote in message
>>> news:678C3394-E594-45A7-A489-(E-Mail Removed)...
>>> > Can I add a date stamp (and or a User stamp) in a Text or Memo Field
>>> > when
>>> > a
>>> > user updates my notes field (Memo)
>>>
>>>
>>>
>
>

On Mon, 4 Apr 2005 16:13:01 -0700, Michael L <Michael
(E-Mail Removed)> wrote:

>Can I add a date stamp (and or a User stamp) in a Text or Memo Field when a
>user updates my notes field (Memo)

As Ken says - you can; but you *shouldn't*. Fields should be atomic. A
text note and a timestamp are two different pieces of information!

Might you consider adding a Date/Time field (default value Now()) to
your table, so that when a record (including a note) is entered the
time that it was entered is automatically retained, just in a
different field?

John W. Vinson[MVP]

The Date/Time field with the Now() default works great for indicating when a
record is entered. But how would you implement a "Date Last Changed"
Date/Time field that would change to Now() whenever anything in the record is
changed? I suspect it might be based on the BeforeUpdate event but I can't
find anything on the actual mechanics of it.

"John Vinson" wrote:

> On Mon, 4 Apr 2005 16:13:01 -0700, Michael L <Michael
> (E-Mail Removed)> wrote:
>
> >Can I add a date stamp (and or a User stamp) in a Text or Memo Field when a
> >user updates my notes field (Memo)
>
> As Ken says - you can; but you *shouldn't*. Fields should be atomic. A
> text note and a timestamp are two different pieces of information!
>
> Might you consider adding a Date/Time field (default value Now()) to
> your table, so that when a record (including a note) is entered the
> time that it was entered is automatically retained, just in a
> different field?
>
> John W. Vinson[MVP]
>

On Fri, 8 Apr 2005 13:51:02 -0700, "mdavidjohnson"
<(E-Mail Removed)> wrote:

>The Date/Time field with the Now() default works great for indicating when a
>record is entered. But how would you implement a "Date Last Changed"
>Date/Time field that would change to Now() whenever anything in the record is
>changed? I suspect it might be based on the BeforeUpdate event but I can't
>find anything on the actual mechanics of it.

Quite correct. Something like this in the Form's BeforeUpdate:

Private Sub Form_BeforeUpdate(Cancel as Integer)
<put any validation code here, set Cancel to True and exit if there is
a validation error>
<if all is well...>
Me!DateLastChanged = Now
End Sub

John W. Vinson[MVP]

That worked fine. Thank you.

But suppose I go in and change something directly in a table without using a
form. Is there any way to ensure that the "Date Last Changed" field gets
updated then too?

"John Vinson" wrote:

> On Fri, 8 Apr 2005 13:51:02 -0700, "mdavidjohnson"
> <(E-Mail Removed)> wrote:
>
> >The Date/Time field with the Now() default works great for indicating when a
> >record is entered. But how would you implement a "Date Last Changed"
> >Date/Time field that would change to Now() whenever anything in the record is
> >changed? I suspect it might be based on the BeforeUpdate event but I can't
> >find anything on the actual mechanics of it.
>
> Quite correct. Something like this in the Form's BeforeUpdate:
>
> Private Sub Form_BeforeUpdate(Cancel as Integer)
> <put any validation code here, set Cancel to True and exit if there is
> a validation error>
> <if all is well...>
> Me!DateLastChanged = Now
> End Sub
>
> John W. Vinson[MVP]
>

mdavidjohnson wrote:
> That worked fine. Thank you.
>
> But suppose I go in and change something directly in a table without
> using a form. Is there any way to ensure that the "Date Last Changed"
> field gets updated then too?

Nope. Not unless you use a server database that supports triggers for the back
end.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com