How can I make the date field change automatically when I make a .

How can I make the date field change that I set up automatically change when
I make changing in my other fields... etc. If I change a persons name in the
name field, I want my date field to reflect and change when I made the
change.

Put the following code in the BeforeUpdate event of your data entry form.

Me.txtYourDateField = Date()

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Ngina 28" Ngina wrote in message
...
How can I make the date field change that I set up automatically change
when
I make changing in my other fields... etc. If I change a persons name in
the
name field, I want my date field to reflect and change when I made the
change.

Lynn -

I have a field called lastUpdated and it is a manual field that we change
whenever we get a new email/phone/address/add a course, etc in a training
table.

What coding do I use for that field? I tried it on the berfore and also on
the after update field and still didn't have any luck.

I do this on the form...for the field lastUpdated...and put that event in
there, right?

Thanks!!!
Tony

"Lynn Trapp" wrote:

Put the following code in the BeforeUpdate event of your data entry form.

Me.txtYourDateField = Date()

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Ngina 28" Ngina wrote in message
...
How can I make the date field change that I set up automatically change
when
I make changing in my other fields... etc. If I change a persons name in
the
name field, I want my date field to reflect and change when I made the
change.

Putting the code in the Before Update will cause it to update when you make
a change to the record, but not if you simply view the record.


Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.LastUpdate = Date()
End Sub




Rick B




"Tony" wrote in message
...
Lynn -

I have a field called lastUpdated and it is a manual field that we change
whenever we get a new email/phone/address/add a course, etc in a training
table.

What coding do I use for that field? I tried it on the berfore and also
on
the after update field and still didn't have any luck.

I do this on the form...for the field lastUpdated...and put that event in
there, right?

Thanks!!!
Tony

"Lynn Trapp" wrote:

Put the following code in the BeforeUpdate event of your data entry
form.

Me.txtYourDateField = Date()

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Ngina 28" Ngina wrote in message
...
How can I make the date field change that I set up automatically
change
when
I make changing in my other fields... etc. If I change a persons name
in
the
name field, I want my date field to reflect and change when I made the
change.

I haven't done any coding in Access before. Where do I insert that code?
And what does "Me" standfor in Me.LastUpdate?

We have a responder table that holds most of the info and we wanted this
lastUpdated to change when we touch any of the others...will that be the case?

Thanks Rick!
Tony

"Rick B" wrote:

Putting the code in the Before Update will cause it to update when you make
a change to the record, but not if you simply view the record.


Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.LastUpdate = Date()
End Sub




Rick B




"Tony" wrote in message
...
Lynn -

I have a field called lastUpdated and it is a manual field that we change
whenever we get a new email/phone/address/add a course, etc in a training
table.

What coding do I use for that field? I tried it on the berfore and also
on
the after update field and still didn't have any luck.

I do this on the form...for the field lastUpdated...and put that event in
there, right?

Thanks!!!
Tony

"Lynn Trapp" wrote:

Put the following code in the BeforeUpdate event of your data entry
form.

Me.txtYourDateField = Date()

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Ngina 28" Ngina wrote in message
...
How can I make the date field change that I set up automatically
change
when
I make changing in my other fields... etc. If I change a persons name
in
the
name field, I want my date field to reflect and change when I made the
change.

You need to open the form in design-view. Go into the form's properties box
and find the "update" event. double-click in that field or select "event
procedure" from the drop down, then click the elipse to the right (...).
Update the code window as outlined in my earlier post.

Hope that helps.

Rick B


"Tony" wrote in message
...
I haven't done any coding in Access before. Where do I insert that code?
And what does "Me" standfor in Me.LastUpdate?

We have a responder table that holds most of the info and we wanted this
lastUpdated to change when we touch any of the others...will that be the
case?

Thanks Rick!
Tony

"Rick B" wrote:

Putting the code in the Before Update will cause it to update when you
make
a change to the record, but not if you simply view the record.


Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.LastUpdate = Date()
End Sub




Rick B




"Tony" wrote in message
...
Lynn -

I have a field called lastUpdated and it is a manual field that we
change
whenever we get a new email/phone/address/add a course, etc in a
training
table.

What coding do I use for that field? I tried it on the berfore and
also
on
the after update field and still didn't have any luck.

I do this on the form...for the field lastUpdated...and put that event
in
there, right?

Thanks!!!
Tony

"Lynn Trapp" wrote:

Put the following code in the BeforeUpdate event of your data entry
form.

Me.txtYourDateField = Date()

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Ngina 28" Ngina wrote in message
...
How can I make the date field change that I set up automatically
change
when
I make changing in my other fields... etc. If I change a persons
name
in
the
name field, I want my date field to reflect and change when I made
the
change.

Note: the "me" indicates the current object (the form).


"Tony" wrote in message
...
I haven't done any coding in Access before. Where do I insert that code?
And what does "Me" standfor in Me.LastUpdate?

We have a responder table that holds most of the info and we wanted this
lastUpdated to change when we touch any of the others...will that be the
case?

Thanks Rick!
Tony

"Rick B" wrote:

Putting the code in the Before Update will cause it to update when you
make
a change to the record, but not if you simply view the record.


Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.LastUpdate = Date()
End Sub




Rick B




"Tony" wrote in message
...
Lynn -

I have a field called lastUpdated and it is a manual field that we
change
whenever we get a new email/phone/address/add a course, etc in a
training
table.

What coding do I use for that field? I tried it on the berfore and
also
on
the after update field and still didn't have any luck.

I do this on the form...for the field lastUpdated...and put that event
in
there, right?

Thanks!!!
Tony

"Lynn Trapp" wrote:

Put the following code in the BeforeUpdate event of your data entry
form.

Me.txtYourDateField = Date()

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Ngina 28" Ngina wrote in message
...
How can I make the date field change that I set up automatically
change
when
I make changing in my other fields... etc. If I change a persons
name
in
the
name field, I want my date field to reflect and change when I made
the
change.