Still not solved! Show date of changed data in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is not really a new question. I'm still having problems putting a box
on my form which shows the date the data was last changed. I've tried the
solutions kindly sent in by Roger Carlson and John Vinson, but I'm obviously
not sufficiently experienced with the terms used.

I've added a 'date/time' field called 'UpdatedOn' to my table. On the form
I've tried various ways of putting the relevant box on view, but nothing
seems to work. I've followed Roger's sequence, but the code "Private Sub
Form........." doesn't appear.

Any more tips? Preferably in a-z steps for a comparative novice!!

Many thanks
Ishbel Kargar
 
Ishbel

If both Roger and John have provided solutions, I strongly suspect you have
a solution.

Instead of starting over (for example, I haven't seen what Roger and John
suggested), why not ask either/both of them to clarify any points with which
you are having problems? They are most familiar with what you've described,
and what they've suggested.

And it could turn out to be a relatively simple alteration in something
already suggested...
 
In the table, did you give your UpdatedOn field a Format like ShortDate?

On the Form, put a textbox. In the properties:
Name: txtUpdatedOn
Control Source: UpdatedOn

Bring up the properties for the Form:
Click on the Event tab.
Click in On Dirty.
Click the ... button to the right.
Click on Code Builder and click OK. The following will appear:

Private Sub Form_Dirty(Cancel As Integer)

End Sub

In the blank line, type:
Me!txtUpdatedOn = Date

HTH,
Debbie


| This is not really a new question. I'm still having problems putting a box
| on my form which shows the date the data was last changed. I've tried the
| solutions kindly sent in by Roger Carlson and John Vinson, but I'm obviously
| not sufficiently experienced with the terms used.
|
| I've added a 'date/time' field called 'UpdatedOn' to my table. On the form
| I've tried various ways of putting the relevant box on view, but nothing
| seems to work. I've followed Roger's sequence, but the code "Private Sub
| Form........." doesn't appear.
|
| Any more tips? Preferably in a-z steps for a comparative novice!!
|
| Many thanks
| Ishbel Kargar
 
Debbie, you're a gem!

Many thanks. It seems to be working now. Although the field is blank for
all the records (obviously, because they've not yet been changed), I tested
it by changing some data on my own record, and todays date popped up in the
'updated on' field.

So I presume that eventually, all the records will show a date in this
field, could take a while though, as I only update for change of address,
subs renewal, etc.

MANY THANKS!!

Ishbel
 
You're welcome.

| Debbie, you're a gem!
|
| Many thanks. It seems to be working now. Although the field is blank for
| all the records (obviously, because they've not yet been changed), I
tested
| it by changing some data on my own record, and todays date popped up in
the
| 'updated on' field.
|
| So I presume that eventually, all the records will show a date in this
| field, could take a while though, as I only update for change of address,
| subs renewal, etc.
|
| MANY THANKS!!
|
| Ishbel
 
Back
Top