Applying a Time/Date Stamp to tables

  • Thread starter Thread starter Deeann
  • Start date Start date
D

Deeann

I am trying to create a date stamp which is added to a
table(s) every time a record is modified. I tried to use
a macro(which I do not like to use)that is like article
209637 on the MS knowledge base. The error I get is:

You tried to run a VB procedure to set a property or
method for an object. However the component doesn't make
the method available for automation.

I don't really understand this error. Is there a way to
add the date stamp?

Thanks,
Deeann
 
Add a field to your table, date/time type, named
LastUpdated. Set its defautl property to "=Now()"

Now, in your form, add the field to the form. Then, click
on properties, events, and for the AfterUpdate select
[Event Procedure]. Click the builder button (3 dots), and
you're in the VBA Editor.

Add the line:

Me.LastUpdated=Now()


Chris Nebinger
 
Thank you. Is there also a way to date an individual
record and/or field?

Deeann
-----Original Message-----
Add a field to your table, date/time type, named
LastUpdated. Set its defautl property to "=Now()"

Now, in your form, add the field to the form. Then, click
on properties, events, and for the AfterUpdate select
[Event Procedure]. Click the builder button (3 dots), and
you're in the VBA Editor.

Add the line:

Me.LastUpdated=Now()


Chris Nebinger

-----Original Message-----
I am trying to create a date stamp which is added to a
table(s) every time a record is modified. I tried to use
a macro(which I do not like to use)that is like article
209637 on the MS knowledge base. The error I get is:

You tried to run a VB procedure to set a property or
method for an object. However the component doesn't make
the method available for automation.

I don't really understand this error. Is there a way to
add the date stamp?

Thanks,
Deeann
.
Click to expand...
.
Click to expand...
 
Back
Top