By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

How do I automatically update a date field upon data entered into another field?

P: n/a
This concerns an Access 2002 (XP) database. There are two fields,
"Notes" (Memo Field) and "Notes Update" on a form (among others)
which I am concerned with here.

Problem: I need to be able to tell when people have added notes to a
record. (this database contains 6000+ records)

I want to set it up so that "Notes Update" is updated to the current
date whenever someone actually enters data into, or modifies data in,
the "Notes" field (but NOT when just browsing the information in the
field).
How I tried to solve the problem:

I added a field called "Notes Update" in a date format to the table.

I wrote a macro and put it into the "After Update" field of the
"Notes" Field on the form. The macro simply jumped to the "Notes
Update" field.

I put =Date() in the "On enter" property of the "Notes Update" field
on the form.

My hope was that an entry in the "Notes" field would trigger a jump to
the "Notes Update" field, which would then cause Date() to put that
day's date into the field.

I also removed the tab stop from the "Notes Update" field to prevent
anyone tabbing to the field and changing the date that way.

Unfortunately it didn't work.

Can anyone suggest the best way to get this to happen?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Create a Text Box bound to your last-updated-on field, set the value to
either Date() or Now() as you prefer in the BeforeUpdate event for the
record. The event won't fire unless the record is being saved. Seems too
simple -- maybe I missed something?

Larry Linson
Microsoft Access MVP

"BlackFireNova" <BF*****************@myrealbox.com> wrote in message
news:8d**************************@posting.google.c om...
This concerns an Access 2002 (XP) database. There are two fields,
"Notes" (Memo Field) and "Notes Update" on a form (among others)
which I am concerned with here.

Problem: I need to be able to tell when people have added notes to a
record. (this database contains 6000+ records)

I want to set it up so that "Notes Update" is updated to the current
date whenever someone actually enters data into, or modifies data in,
the "Notes" field (but NOT when just browsing the information in the
field).
How I tried to solve the problem:

I added a field called "Notes Update" in a date format to the table.

I wrote a macro and put it into the "After Update" field of the
"Notes" Field on the form. The macro simply jumped to the "Notes
Update" field.

I put =Date() in the "On enter" property of the "Notes Update" field
on the form.

My hope was that an entry in the "Notes" field would trigger a jump to
the "Notes Update" field, which would then cause Date() to put that
day's date into the field.

I also removed the tab stop from the "Notes Update" field to prevent
anyone tabbing to the field and changing the date that way.

Unfortunately it didn't work.

Can anyone suggest the best way to get this to happen?

Nov 12 '05 #2

P: n/a
Larry:

I understand what you are saying about the text box, however I want
that date to be placed into the table, so a record of the updated date
is maintained. How do I get the date, once placed into the text box,
into the field in the table?

BFN
Nov 12 '05 #3

P: n/a
On 14 Oct 2003 20:45:47 -0700, BF*****************@myrealbox.com
(BlackFireNova) wrote:

Presumably the field would be bound to the corresponding field in the
table.

-Tom.

Larry:

I understand what you are saying about the text box, however I want
that date to be placed into the table, so a record of the updated date
is maintained. How do I get the date, once placed into the text box,
into the field in the table?

BFN


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.