Find date of last record entry for current user

[p-rat]

Is there any way for a Date field to pull in the last time the
currentuser created a record? If so, can this field be edited (want a
different date other than last time record created)?

Also, if this isn't possible is there a way to put in a Calendar?

 

[John W. Vinson]

Is there any way for a Date field to pull in the last time the
currentuser created a record? If so, can this field be edited (want a
different date other than last time record created)?

Access does not track this information. You can do so yourself - insert a
Date/Time field WhenAdded with a default value of Now. This will timestamp
each record with its creation date and time, and it can be edited (though you
can conceal it from user view by making the user do all interaction via a
Form... and just don't include that field, or display it in a Locked control).

Also, if this isn't possible is there a way to put in a Calendar?

A2007 has a builtin calendar control, and you can add a calendar control to
earlier versions. A calendar by itself will not track when records are added
or altered, though!

John W. Vinson [MVP]

 

[Linq Adams via AccessMonster.com]

You'd also have to include a field to hold currentuser, would you not, then
do soemthing like use DMax() for the date where currentuserfield =
currentuser?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com